Prev: Scatterpoot not using X values properly -- using relative ranking
Next: chart
From: Melody on 12 Mar 2010 13:06
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.
From: FloMM2 on 13 Mar 2010 00:49
Melody,
I have to do a similar thing every month, so I know how you feel.
This is what I came up with:
Is the chart on a separate sheet? If so, select the chart "sheet" and then
left click on the chart. You should see a box around your chart with squares
on the lines.
Now select the sheet with the data, you should see colored boxes
high-lighting you data. Drag and drop both boxes to include the third month,
"March" in your example.
If the chart is on the same sheet as the data it is easy to do also.
When you select the data, you will see the boxes high-light your data. The
process is the same.
There are other ways to do this, this is what works for me and hopefully for
you.
hth
"Melody" wrote:

> 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.
From: Melody on 15 Mar 2010 09:13
Thanks for the reply but that's not the resolution. I actually have all
months thru December as part of my data source but we are only up to March as
far as having data available. I tried even limiting my data source to 3
months and the chart still does the same thing.

"FloMM2" wrote:

> Melody,
> I have to do a similar thing every month, so I know how you feel.
> This is what I came up with:
> Is the chart on a separate sheet? If so, select the chart "sheet" and then
> left click on the chart. You should see a box around your chart with squares
> on the lines.
> Now select the sheet with the data, you should see colored boxes
> high-lighting you data. Drag and drop both boxes to include the third month,
> "March" in your example.
> If the chart is on the same sheet as the data it is easy to do also.
> When you select the data, you will see the boxes high-light your data. The
> process is the same.
> There are other ways to do this, this is what works for me and hopefully for
> you.
> hth
> "Melody" wrote:
>
> > 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.
 | 
Pages: 1
Prev: Scatterpoot not using X values properly -- using relative ranking
Next: chart