View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Melody Melody is offline
external usenet poster
 
Posts: 51
Default Chart moves on plot area when adding a third month

I am working on an area chart that I update weekly. It's a very simple
chart. The data looks like this:

Month Count
Jan-10 401
Feb-10 435
Mar-10 450

Currently the chart is only using Jan-Feb data. I'm trying to add March to
the scale however every time I do the graph condenses and then relocates to
the center of the plot area. I've used this same file for my 2009 data and
never had a problem. It only does this when I add the third month because if
I add Mar but take Jan off it works fine. Got any suggestions? I'm using
Excel 2003. Thanks.