Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a spread sheet with the following three series:
Series 1 (column 1) is A:2 through A:25, formatted date, values Jan 2005 through Dec 2005 Series 2 (column 2) is B:2 through B:25, fomatted number, values integers Series 3 (column 3) is C:2 through C:25, formatted number, values integers I select these three columns and then invoke the chart wizard to make a line chart based on them. Series 2 (column 2) is assigned to one line of the chart. Series 3 (column 3) is assigned to another line. Series 1 (column 1), the list of dates, is assigned to the "Category (X) axis label". When Excel creates the chart, the list of dates beneath the X axis is extended from Dec 2005 all the way out August 2006, even though the list ends with Dec 2005 and there are no values for these dates. Anybody know what's going on? Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Chart Auto Expand Problem | Excel Discussion (Misc queries) | |||
Title Block in Excel Chart - Size problem | Charts and Charting in Excel | |||
Excel chart problem | Excel Worksheet Functions | |||
Dynamic Bar Chart Category Axis Problem | Charts and Charting in Excel | |||
export chart - size problem | Charts and Charting in Excel |