Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Michael Ryle
 
Posts: n/a
Default Chart Problem

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Chart Auto Expand Problem Mike Fox Excel Discussion (Misc queries) 0 January 2nd 06 10:58 AM
Title Block in Excel Chart - Size problem Stuart Saich Charts and Charting in Excel 1 October 25th 05 11:44 AM
Excel chart problem Mike1 Excel Worksheet Functions 0 September 13th 05 10:48 PM
Dynamic Bar Chart Category Axis Problem Richard Charts and Charting in Excel 1 September 13th 05 09:51 AM
export chart - size problem Art Parra Charts and Charting in Excel 1 December 7th 04 01:58 AM


All times are GMT +1. The time now is 01:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"