#1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2
Default Change Chart Size

I was wondering if anyone knows how I can change the sizes of charts in
excel. But i dont want to just resize by dragging the corners, i want to
lock the aspect ratio, and change the width to 3.5 inches. So basically, i
want to change the width of each chart to 3.5 inches exactly.

Another problem I am having is when I copy and paste a chart from excel into
powerpoint, all the changes to the size and text I made get changed so its
not the copy I wanted. Is there any way to change this.
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 989
Default Change Chart Size


1) Resize using aspect ratio only after the chart is sucessfully in
Powerpoint.

2) You get charts into Powerpoint:

Create the chart in a new Tab in Excel (Right click on a tab at the bottom
of your Sheet. Select "Insert" then "Chart"... you get a new Tab.. follow
instructions and create your chart)

Alter size and font size within the chart tab before copying.

After completing the chart, select the chart and "Copy".
Go to Powerpoint and simply Paste.

It should past without resizing.

3) Resize the chart in powerpoint... using aspect ratio:

Right click on the chart object.
Format Object
Size

You will then be on a control panel which allows you to resize with aspects
etc...


Hope this helps





"bhavesh" wrote:

I was wondering if anyone knows how I can change the sizes of charts in
excel. But i dont want to just resize by dragging the corners, i want to
lock the aspect ratio, and change the width to 3.5 inches. So basically, i
want to change the width of each chart to 3.5 inches exactly.

Another problem I am having is when I copy and paste a chart from excel into
powerpoint, all the changes to the size and text I made get changed so its
not the copy I wanted. Is there any way to change 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
Data Range Mess Karen Charts and Charting in Excel 18 January 14th 06 02:34 PM
how to change range for dynamic chart in excel 2000 with button? ivan Charts and Charting in Excel 2 April 24th 05 04:10 AM
How to change Series Order in a Combination Chart? vrk1 Excel Discussion (Misc queries) 0 March 31st 05 11:19 PM
ho to change in the bubble chart the bubble position and size laszlo Charts and Charting in Excel 0 March 25th 05 04:45 PM
How do I change the size of the text box in a flow chart? Breanne Charts and Charting in Excel 1 January 6th 05 06:05 PM


All times are GMT +1. The time now is 05:06 AM.

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

About Us

"It's about Microsoft Excel"