y axis problems in chart

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

gbl - 12 Aug 2006 20:06 GMT

no matter what data i have entered on the chart datasheet, i keep getting
unrelated nonsence #s on the y axis

Reply to this Message

Echo S - 12 Aug 2006 22:31 GMT

> no matter what data i have entered on the chart datasheet, i keep getting
> unrelated nonsence #s on the y axis

Double-click the axis and see what you have selected on the Number tab.

Also check Chart|Chart Options. Depending on the chart, you might have a
time-scale selected or something (although I think that may apply only to
the X axis.)

If those aren't the problem, then post back and tell us what chart type
you're working with, what the data in the data sheet says, and what the
numbers you see on the Y axis actually are.

Signature

Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances http://www.oreilly.com/catalog/powerpointannoy/
PPTLive! Sept 17-20, 2006 http://www.pptlive.com

Reply to this Message

gbl - 13 Aug 2006 03:54 GMT

no didn't work i still have the problems especially in 2d bar and line
charts. I have have an array that mshows for example the % of people who
respond yes or no over a 6 yr period. while the ppolot area is perfect i may
get constant values showing on on the y acecss ( major values) sch as -233,
-233, -233. hoever, when i add data labels (values) the corect values show
on the chart. the problem is just with the y axis

> > no matter what data i have entered on the chart datasheet, i keep getting
> > unrelated nonsence #s on the y axis
[quoted text clipped - 8 lines]
> you're working with, what the data in the data sheet says, and what the
> numbers you see on the Y axis actually are.

Reply to this Message

Echo S - 13 Aug 2006 15:20 GMT

Are you working in PPT 2007, by any chance?

Signature

> no didn't work i still have the problems especially in 2d bar and line
> charts. I have have an array that mshows for example the % of people who
[quoted text clipped - 19 lines]
>> you're working with, what the data in the data sheet says, and what the
>> numbers you see on the Y axis actually are.

Reply to this Message

Echo S - 19 Aug 2006 15:40 GMT

Well, since I haven't received a response from the original poster, I'll at
least post this in case anyone else has this issue.

This is a known bug in Beta 2 of PowerPoint 2007. (I know because I reported
it quite some time ago.) It has been fixed, but I don't know if it will show
up in the Beta 2 Technical Refresh or not.

Folks, it really helps to mention which version of PPT you're using.

Signature

> Are you working in PPT 2007, by any chance?
>
[quoted text clipped - 22 lines]
>>> you're working with, what the data in the data sheet says, and what the
>>> numbers you see on the Y axis actually are.

Reply to this Message

google@istcd.com - 06 Sep 2006 01:23 GMT

It carries backward. I edited a presentation started in 2000 with
2007B2, and kept hitting the same problem, even though I gave up and
edited it in 2003. It also affects new charts made in the existing
presentation (2000-->2007-->2003). Glad to know I'm not nuts. Not
thrilled there isn't a solution. Sigh...

Neman
neman@istcd*THISPARTISBOGUS*.com

> Well, since I haven't received a response from the original poster, I'll at
> least post this in case anyone else has this issue.
[quoted text clipped - 51 lines]
> >>> http://www.oreilly.com/catalog/powerpointannoy/
> >>> PPTLive! Sept 17-20, 2006 http://www.pptlive.com

Reply to this Message

Echo S - 06 Sep 2006 02:39 GMT

You're definitely not nuts, but it is rather freaky when it happens. :-)

IIRC, it's associated with compatibility mode. If you're making your edits
while in "straight 2007 mode," the axis should be okay. I think. Basically,
that means you open your PPT file and save it as a PPT 2007 file (.PPTX).
Then do your editing. Finally, save it back to 2003-compatible .PPT once
you've completed the editing.

Signature

> It carries backward. I edited a presentation started in 2000 with
> 2007B2, and kept hitting the same problem, even though I gave up and
[quoted text clipped - 71 lines]
>> >>> http://www.oreilly.com/catalog/powerpointannoy/
>> >>> PPTLive! Sept 17-20, 2006 http://www.pptlive.com

Reply to this Message