Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
excel chart size using inside positioning | Charts and Charting in Excel | |||
How to change the color of all series in an excel chart in one go. | Charts and Charting in Excel | |||
How can I save an editable copy of a protected excel workbook? | Excel Discussion (Misc queries) | |||
How do I insert an Excel file into a PowerPoint Presentation slid. | Excel Worksheet Functions | |||
Excel and Powerpoint | Excel Discussion (Misc queries) |