If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Chart moves on plot area when adding a third month
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. |
#3
|
|||
|
|||
Chart moves on plot area when adding a third month
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. |
Thread Tools | |
Display Modes | |
|
|