LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default how can I make different charts the same size?

When you hold Alt while dragging and resizing charts on a worksheet, the
edges of the chart stick to cell boundaries. Simply align one chart within a
particular range of cells, then resize all charts to this range, or a range
that is sized the same.

To get the formatting the same, select the chart area of one chart and copy
it, then select another chart, and use paste special to paste the formats
from the first chart onto the second. Repeat for all of your other charts.

Note, not only are formats copies, but so are the text contents of chart and
axis titles, data labels, etc.

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


"Sharon" wrote in message
...
I need a scientific poster, and I need to present my results. I want the
graphs to have the same size and format. I know I can do this one by one,
but I would like to know if I can do it with a specific comand to keep the
same style and size of each chart.

Thanks!!!



 
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
Unstable charts size kaa_63[_2_] Charts and Charting in Excel 0 January 6th 08 07:14 PM
I need to create 3 pie charts that are same size . . . PYC Charts and Charting in Excel 0 May 3rd 07 01:03 AM
How do you keep charts - graphs the same size? datamonkey Charts and Charting in Excel 0 January 24th 06 12:57 PM
How do I make all pie charts identical in size Bliss Excel Worksheet Functions 1 June 12th 05 03:39 PM
initial size of new charts bob m Charts and Charting in Excel 1 January 22nd 05 02:19 AM


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

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"