Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Series name
When I select data for a chart, excel does not use the top row as series
names (in fact uses them as values - they are text identifiers such as 7004, 7005, etc. but I have formatted as text). I can not select top row and put Series names in one by one, but I have 54 series! Do I have some option turned off? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Series name
Clear the cell in the top left of the range (above the X values and left of
the series names). Then make the chart. The blank cell indicates to Excel that the top row and first column are special, so it can parse the range properly. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Fred Zack" wrote in message ... When I select data for a chart, excel does not use the top row as series names (in fact uses them as values - they are text identifiers such as 7004, 7005, etc. but I have formatted as text). I can not select top row and put Series names in one by one, but I have 54 series! Do I have some option turned off? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2nd Axes - primary series data of only 1 series disappears! | Charts and Charting in Excel | |||
Changing series information for approximately 60 series in a workb | Charts and Charting in Excel | |||
chart data series -- plot a table as a single series | Charts and Charting in Excel | |||
how do I change a line series to a column series in excel? | Charts and Charting in Excel | |||
series graph -- one series being added to another series | Charts and Charting in Excel |