View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Line Chart Format (Actual vs. Forecast)

Your X axis is "cut short" how? I simply selected the data and created a
chart, and I got months Oct thru Sept (except for May, missing in your
data), with one line from Oct to Nov and the other from Nov to Sept.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


<John Scola wrote in message ...
Hello,

I am doing something similar to what Sahafi is doing except I am doing
monthly budget data. My chart data looks as follows...

Col A Col B Col C
Oct 1000
Nov 3000 3000
Dec 4000
Jan 5000
Feb 6000
Mar 7000
Apr 8000
Jun 9000
Jul 10000
Aug 11000
Sept 12000

The numeric data is gotten via paste links to cells in a different sheet
within the same workbook that use VB functions to calculate the cell
values. However, when I go to plot the data, my x-axis for the months is
cut short and I do not see a line for the data in column B. Any ideas
what might be going on?