Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
chart area & plot area | New Users to Excel | |||
How do you show plot area only-no chart area | Charts and Charting in Excel | |||
Resize plot area in a chart area | Excel Discussion (Misc queries) | |||
How to increase chart area without affecting plot area? | Charts and Charting in Excel | |||
Resize chart area without resizing plot area | Charts and Charting in Excel |