G
Guest
I have created a simple, horizontal stacked bar chart for a client which is
sandwiched in the overlay between groups of autoshapes. As this bar chart
will be updated quarterly, it is important that (1) the horizontal placement
of the Y axis and length of longest stack always remain constant in relation
to the surrounding graphics, and (2) the X axis scale be adjusted to
accommodate the new total of the longest stacked bar. Currently the best I
can do regarding #2 is require the client to go in and manually change the
maximum X axis scale to that new largest total, but I would like it to be
more automated and user friendly for non-PowerPoint people to use. But even
with the manual adjustment of the X axis scale I have found that the Y axis
moves horizontally on the slide while the right edge of the plot area remains
constant. I would, at least, prefer the opposite. Because of that, the user
would also be required to scale the chart area horizontally back to the
proper location. That is asking the user to do too much since the relative
position of the graphics are hidden from view while in graph edit mode and
scaling the graph outside of graph edit mode distorts the graph text and
screws up the graph in general for future edits. I can’t use a 100% stacked
bar since the lengths of the other stacked bars need to remain relative to
the longest stack. Any suggestions? I can’t believe in almost 10 years of
doing PowerPoint on a regular basis I haven’t had to deal with this before.
A tet file can be downloaded from
http://www.doug-morgan.com/tmp936/BarGrahAlignmentIssue.ppt.
Other info: Using PowerPoint 2003 on Windows XP Pro.
Thanks.
sandwiched in the overlay between groups of autoshapes. As this bar chart
will be updated quarterly, it is important that (1) the horizontal placement
of the Y axis and length of longest stack always remain constant in relation
to the surrounding graphics, and (2) the X axis scale be adjusted to
accommodate the new total of the longest stacked bar. Currently the best I
can do regarding #2 is require the client to go in and manually change the
maximum X axis scale to that new largest total, but I would like it to be
more automated and user friendly for non-PowerPoint people to use. But even
with the manual adjustment of the X axis scale I have found that the Y axis
moves horizontally on the slide while the right edge of the plot area remains
constant. I would, at least, prefer the opposite. Because of that, the user
would also be required to scale the chart area horizontally back to the
proper location. That is asking the user to do too much since the relative
position of the graphics are hidden from view while in graph edit mode and
scaling the graph outside of graph edit mode distorts the graph text and
screws up the graph in general for future edits. I can’t use a 100% stacked
bar since the lengths of the other stacked bars need to remain relative to
the longest stack. Any suggestions? I can’t believe in almost 10 years of
doing PowerPoint on a regular basis I haven’t had to deal with this before.
A tet file can be downloaded from
http://www.doug-morgan.com/tmp936/BarGrahAlignmentIssue.ppt.
Other info: Using PowerPoint 2003 on Windows XP Pro.
Thanks.