Updating Charts Automatically

[Sopman]

I'm able to use the Offset in the Insert-Name-Define to update my chart automatically, which has multiple lines, but my legend doesn't display the title for each line. It only comes up Series 1, Series 2, etc.
Is their a way change the legend to reflect what each line represents on my data sheet?

Sopman

 

[byundt]

Sopman,
You can set the name property for each series and thereby replace Series 1, Series 2, etc with text of your own choosing. This text may either be fixed or linked to a cell.
1) Right-click the chart and choose Source Data from the resulting pop-up
2) On the Series tab, select Series 1 in the left pane, then enter your desired name in the "Name" field on the right. You may also type = and then click on a cell
3) Repeat step 2 as necessary for the remaining series

Brad

 

[BlueHorizon]

Hi,
I've found that if I have a blank cell in any cell in the Field Name Row of the data that I use for the chart, it shows the "Series" labels. If you have a blank, fill it in with anything, it won't matter.

HTH,

Best,
Blue Horizon

http://www.bluehorizontraining.com