E
Evan Cater
I have an Excel chart. Originally it was a column chart with two data
series, comparing averages from two different data populations.
Recently I added a third series which put a dotted horizontal line
across the column chart to show the overall average.
When I added that horizontal line I named it "Overall Average = [x]"
and that name immediately showed up in the chart legend at the bottom.
Which was great.
The way this project works is: All of the data for the chart is in a
separate worksheet called "Data." I wipe out all the data and save the
workbook to be used as a template. The data is supplied by an Access
database. I copy all the data from Access and paste it into the
template's "Data" worksheet. And, voila!, we have pretty charts.
The problem is that when I paste the data into the worksheet the third
line of my legend, the one that says "Overall Average =[x]", suddenly
vanishes. The legend lines for the other two series remain.
What's happening here? How can I get it to keep all three lines of the
legend?
Thanks.
series, comparing averages from two different data populations.
Recently I added a third series which put a dotted horizontal line
across the column chart to show the overall average.
When I added that horizontal line I named it "Overall Average = [x]"
and that name immediately showed up in the chart legend at the bottom.
Which was great.
The way this project works is: All of the data for the chart is in a
separate worksheet called "Data." I wipe out all the data and save the
workbook to be used as a template. The data is supplied by an Access
database. I copy all the data from Access and paste it into the
template's "Data" worksheet. And, voila!, we have pretty charts.
The problem is that when I paste the data into the worksheet the third
line of my legend, the one that says "Overall Average =[x]", suddenly
vanishes. The legend lines for the other two series remain.
What's happening here? How can I get it to keep all three lines of the
legend?
Thanks.