Good
Afternoon Darwin,
Thank you for sending this. I just tried it and it works for me
too. This is quite nice to know. I appreciate your efforts
and that you shared it with the class. With a saved template we
can set up a graph once and save it as a template and then the second,
and third, and so on times we need to make a similar plot, we can use
the template. This will save a lot of time and effort.
Thanks again.
best wishes,
Dr. Morrison
----- "Darwin Ehrreich" <djehrrei@mtu.edu>
wrote:
> From: "Darwin Ehrreich" <djehrrei@mtu.edu>
> To: fmorriso@mtu.edu
> Sent: Thursday, October 14, 2010 10:35:03 AM GMT -05:00 US/Canada
Eastern
> Subject: Excel templates
>
> Good morning,
>
> I found out how to save excel templates so that it properly selects
> the xdata and does not just think its a another series.
>
> First create 2 columns of data but only label the ydata on top of
the
> data. Then select the data including the label for the ydata
(you
> will select an empty box above the xdata). Go to insert
chart and
> click on scatter plot. This will create the chart and change
> formatting as desired. Save the template (Chart Tools - Design -
Save as Template). Now when you go to select
> data make sure you have a label on top of the y axis data and not
on
> the x axis data. Any column that has a label on it will be
output as
> a new series and the one column without a label will be your x axis
> data from now on when using that template.
>
> Hope this helps,
>
> Darwin Ehrreich
> Michigan Technological University
> Email: djehrrei@mtu.edu
> Phone:6122478674
_______________________________________________
cmgrad-l mailing list
cmgrad-l@mtu.edu
https://lists.coe.mtu.edu/mailman/listinfo/cmgrad-l
|
|