y axis problems in chart

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

no matter what data i have entered on the chart datasheet, i keep getting
unrelated nonsence #s on the y axis
 
gbl said:
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.
 
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
gbl said:
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.

--
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
 
Are you working in PPT 2007, by any chance?

--
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


gbl said:
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
gbl said:
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.

--
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
 
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.

--
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


Echo S said:
Are you working in PPT 2007, by any chance?

--
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


gbl said:
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
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.

--
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
 
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

Echo said:
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.

--
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


Echo S said:
Are you working in PPT 2007, by any chance?

--
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


gbl said:
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

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.

--
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
 
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.

--
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


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

Echo said:
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.

--
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


Echo S said:
Are you working in PPT 2007, by any chance?

--
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


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

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.

--
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
 
Back
Top