Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Top of bars cut off in bar graph after changing data.
0 views
Skip to first unread message
MJ
Dec 2, 2008, 5:09:02 PM12/2/08
to
I'm having to update a series of bar graphs with 2008 data and when I update
the data, if the number is higher than the previous highest number, the top
of the bar gets cut off. When I try to resize the entire graph, plot area or
anything else, it still stays cut off and just scales.
the data, if the number is higher than the previous highest number, the top
of the bar gets cut off. When I try to resize the entire graph, plot area or
anything else, it still stays cut off and just scales.
How can I get the new data to fit the current chart size?
--
MJ
New America Foundation - http://newamerica.net
Suzanne S. Barnhill
Dec 2, 2008, 5:46:53 PM12/2/08
to
Try changing the scale range to a higher number. The default is "automatic,"
but you can specify a range. Do this by right-clicking in the number area
and choosing Format Axis. Then, on the Scale tab, set the Maximum to a
higher number.
but you can specify a range. Do this by right-clicking in the number area
and choosing Format Axis. Then, on the Scale tab, set the Maximum to a
higher number.
--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
"MJ" <M...@discussions.microsoft.com> wrote in message
news:259C2F81-0348-40F3...@microsoft.com...
MJ
Dec 2, 2008, 6:07:02 PM12/2/08
to
I thought that's what the problem was, but I can't find any scale options for
the height.
the height.
This is what I'm seeing when I bring the Axis dialog up:
http://www.newamerica.net/files/graph-ss-1.jpg
I'm confused.
--
MJ
New America Foundation - http://newamerica.net
Suzanne S. Barnhill
Dec 2, 2008, 11:31:29 PM12/2/08
to
It would appear that you clicked in the category (X) axis rather than the
value (Y) axis. Since it would appear that your Y axis isn't displayed,
you'll have to try just right-clicking on the left side of the chart until
you hit the place where the axis would be, then use Format Axis.
value (Y) axis. Since it would appear that your Y axis isn't displayed,
you'll have to try just right-clicking on the left side of the chart until
you hit the place where the axis would be, then use Format Axis.
--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
"MJ" <M...@discussions.microsoft.com> wrote in message
news:992FAB60-D121-4B92...@microsoft.com...
MJ
Dec 3, 2008, 4:29:14 PM12/3/08
to
I was trying that when I stumbled across something: I actually had the entire
Y-axis display turned off. Once I turned it back on, I was able to fix the
scale problem.
Y-axis display turned off. Once I turned it back on, I was able to fix the
scale problem.
Thanks for your help!
0 new messages