Excel - Can series 1,2,3 label in data be RE labeled to different text?

Asked By newbie

20-Nov-09 06:42 PM

I created a chart, a simple 3D chart using the chart wizard. I have 3
columns of information. I have sales, shelf utilization, and gross
profit. I created this chart and i have 3 data series being presented.
Not sure if anyone understands what i am trying to say? I thought
saying i had a data series was the best approach to describing my
problem in my chart.

Well on the right vertical axis i have numbers that the wizard put in
for me. They go from zero to 60. The data series is for the sales,
shelf utilization, and gross profit. Then to the right of the chart i
have labels that say, series 1, series 2, series 3. I would like to
change the name to 2002, 2003, and 2004. Can someone please tell me
how do i do this? I cant figure out how to do this from books at the
library or online searches because i dont know enough about the topic
to be clear?

Andrew

21-Nov-09 01:09 PM

Newbie,

Select your chart, click Chart on the men, then "Source Data"  and choose
the "Series" tab.  Select Series1 and type 2002 into the name box. And
repeat...

If you had column labels at the top of your data, Excel would have used
those as the default names.

HTH,
Bernie
MS Excel MVP

22-Nov-09 02:57 AM

Thank you.

Andrew


se