If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
multiple charts similar size?
Hi,
I have created several charts in excel, however, how can I adjust the size such that all the charts have exactly the sime size? I can do it by hand, but then you still see differences. Is there an easy trick for this? Thanks. Raoul |
#2
|
|||
|
|||
multiple charts similar size?
Hi,
If it is the chart objects that you want sizing then you can use the Select Arrow from the drawing toolbar to select all the charts and then via the Format Object dialog set the size. If it's plotarea size then vba code is the only way to get the sizes the same. Cheers Andy wrote: Hi, I have created several charts in excel, however, how can I adjust the size such that all the charts have exactly the sime size? I can do it by hand, but then you still see differences. Is there an easy trick for this? Thanks. Raoul -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#3
|
|||
|
|||
multiple charts similar size?
I often have several charts on the same sheet, particularly when I am
producing a dashboard. You have two choices: 1) floating charts embedded on sheet or 2) charts fixed to cell(s). For Floating charts - John Walkenbach in his Excel Charts book has a nice macro for sizing floating charts (Size & Align). Chart - Fixed to Cell - One trick that I have found useful is to place my charts in single cells. That way my charts are nicely aligned and I can resize them by adjusting my row height or column width. I have several examples of charts in cells on my web site that may be of interest. http://processtrends.com/TOC_charts.htm ...Kelly "Andy Pope" wrote in message ... Hi, If it is the chart objects that you want sizing then you can use the Select Arrow from the drawing toolbar to select all the charts and then via the Format Object dialog set the size. If it's plotarea size then vba code is the only way to get the sizes the same. Cheers Andy wrote: Hi, I have created several charts in excel, however, how can I adjust the size such that all the charts have exactly the sime size? I can do it by hand, but then you still see differences. Is there an easy trick for this? Thanks. Raoul -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
how do I make multiple pie charts at the same time? | Ed | Charts and Charting | 1 | February 16th, 2006 04:03 AM |
quick charting question for similar charts on multiple sheets | Boon8888 | Charts and Charting | 2 | January 27th, 2006 07:33 PM |
How To Change Fonts In Multiple Charts in a Workbook? | Cweed | Charts and Charting | 1 | August 30th, 2005 12:07 AM |
multiple pie of pie charts | Nerissa | Charts and Charting | 1 | June 11th, 2005 06:02 AM |
Print all charts in a workbook (multiple worksheets) | aewsaws | Charts and Charting | 3 | December 31st, 2004 10:31 AM |