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
|
|||
|
|||
Problem w/X axis in chart (2003)
I didn't get any hits with my first post, so let's try again with a different
subject line. I'm creating stacked bar charts where I'm tracking data from three points in time (one chart for each reporting period). I started this project a year ago and don't remember how I created the first chart, so I decided to just replicate the first chart, then change the data series. I did so by copying the source data range. For some reason, the second chart has a max capacity of 180% (instead of 100%). When I go to Format Axis, the first chart shows the following values under Scale: Value Y Minimum = 0 Max = 100 Major = 20 Minor = 4 Category X crosses at 0 Display Units reads None and is grayed out. Show Display is checked and is grayed out. The Number tab is set as follows: Percentage Decimal = 0 Linked to source checked When I go to Format Axis on the second chart, this is what I find: Scale Min=0 Max=1.8 Major=0.2 Minor=0.04 Category X = 0 Display Units = None but not grayed out Show Units checked and grayed out Number Percentage Decimal=2 Linked to source not checked I go into the Format Axis and try to change Chart 2 so it mimics Chart 1, but the changes don't stay. HELP! |
#2
|
|||
|
|||
Problem w/X axis in chart (2003)
Is the formatting of your source data the same? It sounds like when you
copied it got changed from percentages to numbers. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Helen" wrote: I didn't get any hits with my first post, so let's try again with a different subject line. I'm creating stacked bar charts where I'm tracking data from three points in time (one chart for each reporting period). I started this project a year ago and don't remember how I created the first chart, so I decided to just replicate the first chart, then change the data series. I did so by copying the source data range. For some reason, the second chart has a max capacity of 180% (instead of 100%). When I go to Format Axis, the first chart shows the following values under Scale: Value Y Minimum = 0 Max = 100 Major = 20 Minor = 4 Category X crosses at 0 Display Units reads None and is grayed out. Show Display is checked and is grayed out. The Number tab is set as follows: Percentage Decimal = 0 Linked to source checked When I go to Format Axis on the second chart, this is what I find: Scale Min=0 Max=1.8 Major=0.2 Minor=0.04 Category X = 0 Display Units = None but not grayed out Show Units checked and grayed out Number Percentage Decimal=2 Linked to source not checked I go into the Format Axis and try to change Chart 2 so it mimics Chart 1, but the changes don't stay. HELP! |
#3
|
|||
|
|||
Problem w/X axis in chart (2003)
In both instances, the Number is Percentage. However, with the original
there are zero decimal, while the new chart shows two. When I change the new chart to zero, the changes don't "stick." And there are other issues related to formatting that didn't translate to the second chart and efforts to change don't remain. Helen "Luke M" wrote: Is the formatting of your source data the same? It sounds like when you copied it got changed from percentages to numbers. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Helen" wrote: I didn't get any hits with my first post, so let's try again with a different subject line. I'm creating stacked bar charts where I'm tracking data from three points in time (one chart for each reporting period). I started this project a year ago and don't remember how I created the first chart, so I decided to just replicate the first chart, then change the data series. I did so by copying the source data range. For some reason, the second chart has a max capacity of 180% (instead of 100%). When I go to Format Axis, the first chart shows the following values under Scale: Value Y Minimum = 0 Max = 100 Major = 20 Minor = 4 Category X crosses at 0 Display Units reads None and is grayed out. Show Display is checked and is grayed out. The Number tab is set as follows: Percentage Decimal = 0 Linked to source checked When I go to Format Axis on the second chart, this is what I find: Scale Min=0 Max=1.8 Major=0.2 Minor=0.04 Category X = 0 Display Units = None but not grayed out Show Units checked and grayed out Number Percentage Decimal=2 Linked to source not checked I go into the Format Axis and try to change Chart 2 so it mimics Chart 1, but the changes don't stay. HELP! |
#4
|
|||
|
|||
Problem w/X axis in chart (2003)
Playing with the chart, I decided to start over. I discovered there's more
than one stacked chart style, so tried the other one and discovered that fixed it. Live and learn! "Helen" wrote: I didn't get any hits with my first post, so let's try again with a different subject line. I'm creating stacked bar charts where I'm tracking data from three points in time (one chart for each reporting period). I started this project a year ago and don't remember how I created the first chart, so I decided to just replicate the first chart, then change the data series. I did so by copying the source data range. For some reason, the second chart has a max capacity of 180% (instead of 100%). When I go to Format Axis, the first chart shows the following values under Scale: Value Y Minimum = 0 Max = 100 Major = 20 Minor = 4 Category X crosses at 0 Display Units reads None and is grayed out. Show Display is checked and is grayed out. The Number tab is set as follows: Percentage Decimal = 0 Linked to source checked When I go to Format Axis on the second chart, this is what I find: Scale Min=0 Max=1.8 Major=0.2 Minor=0.04 Category X = 0 Display Units = None but not grayed out Show Units checked and grayed out Number Percentage Decimal=2 Linked to source not checked I go into the Format Axis and try to change Chart 2 so it mimics Chart 1, but the changes don't stay. HELP! |
Thread Tools | |
Display Modes | |
|
|