Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
momtoaj
 
Posts: n/a
Default Copy chart from Excel to Powerpoint

I have a chart that has the left side range from 0 -
700000 @ 100000 increments, but when I select the chart &
then go to Powerpoint to paste the picture it changes the
range to -100000 - 700000 @ 200000 increments.

Anyone know what would cause this?


  #2   Report Post  
Jon Peltier
 
Posts: n/a
Default

The chart must be shrinking in PowerPoint, so the charting engine wants
to use fewer axis ticks. If you've specified a maximum but no minimum,
it will use your maximum and run out where it needs to. If you'd
specified no maximum, it would do 0 to 8xxx by 2xxx. If you specify all
axis parameters, they will not change. Double click the axis, and on the
Scale tab, enter the numbers you want ofr the axis scales, then resist
the urge to check the Auto boxes (if you check Auto, you're giving Excel
license to do what it pleases, and that's partly why you're up this creek).

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

momtoaj wrote:

I have a chart that has the left side range from 0 -
700000 @ 100000 increments, but when I select the chart &
then go to Powerpoint to paste the picture it changes the
range to -100000 - 700000 @ 200000 increments.

Anyone know what would cause this?


  #3   Report Post  
momtoaj
 
Posts: n/a
Default

That did it! Thanks a bunch!


-----Original Message-----
The chart must be shrinking in PowerPoint, so the

charting engine wants
to use fewer axis ticks. If you've specified a maximum

but no minimum,
it will use your maximum and run out where it needs to.

If you'd
specified no maximum, it would do 0 to 8xxx by 2xxx. If

you specify all
axis parameters, they will not change. Double click the

axis, and on the
Scale tab, enter the numbers you want ofr the axis

scales, then resist
the urge to check the Auto boxes (if you check Auto,

you're giving Excel
license to do what it pleases, and that's partly why

you're up this creek).

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

momtoaj wrote:

I have a chart that has the left side range from 0 -
700000 @ 100000 increments, but when I select the

chart &
then go to Powerpoint to paste the picture it changes

the
range to -100000 - 700000 @ 200000 increments.

Anyone know what would cause this?


.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
excel chart size using inside positioning Travis Charts and Charting in Excel 2 February 15th 05 04:10 AM
How to change the color of all series in an excel chart in one go. Mz2 Charts and Charting in Excel 1 January 20th 05 01:07 AM
How can I save an editable copy of a protected excel workbook? randyice Excel Discussion (Misc queries) 1 December 23rd 04 09:01 PM
How do I insert an Excel file into a PowerPoint Presentation slid. Barb Excel Worksheet Functions 1 December 11th 04 04:23 PM
Excel and Powerpoint freekrill Excel Discussion (Misc queries) 0 November 26th 04 01:50 AM


All times are GMT +1. The time now is 04:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"