Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
I'm confused just like David is, but I suspect you have a single series that
changes its name as each month is added to the data. The way to tell Excel what to use as series names is to structure your data like so: [blank] Name Jan $100 Feb $200 Mar $300 The top left cell has to be blank, the cell above the numbers has the series name. Select the entire range for charting, including the top row. Excel uses the cell with the Name for the series name. Change this manually when you add the next month, or write a formula to update it based on the number of months with data. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "Brazuka" wrote in message ... !Hi! I need to build a LINE CHART with diferent SERIES NAMES, but I cannot get different names for the serie. This is the chart JAN $100 FEB $200 MAR$ 300 and so on for the year. Last year I manually change month by month the Serie NAme on the plot area, but there has to be a way to get it when I add the info for the next month. Help? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Multiple charts with same serie names | Charts and Charting in Excel | |||
Using Range Names in Charts | Charts and Charting in Excel | |||
Justifying 2-line category names in bar charts | Charts and Charting in Excel | |||
change last serie to be line in the line-column Excel chart in Wor | Charts and Charting in Excel | |||
Range Names with Charts | Charts and Charting in Excel |