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
|
|||
|
|||
Bar charts - bars irregular size
I'm pasting bar charts (as pictures) into powerpoint slides. (around 300 of
them). The charts are EXTREMELY tiny - font size 3pt (autoscale off!) - i've run the excel gauntlet with axis truncating, fonts distorting etc. and have found fixes for most of it. (after 300 charts, my aunt's cat would have found it!) The bars (when they are correctly sized, are 1mm wide) HOWEVER - one tiny (and potentially project flooring) glitch remain beyond my reach: The bars, once pasted, are completely irregular sizes - some as small as 0.3mm - in the same graph! Soooooo - I have been forced to (wait for this) UNGROUP each chart on the slide, and then MANUALLY select each bar ( ehm, 1,800 of them) and change the size to 1mm!! I've worked on this for around 14 hours. I'm tired. I would so very much like some help. From someone. Please? |
#2
|
|||
|
|||
Mardi -
Since your charts are so small, the narrow bars are also small, and the rounding of the size into pixels is irregular. Some might round to 3 pixels and others to 4. That's a much more visible difference than if some rounded to 23 and others to 24 (if the bars are ~6 mm or ~0.25"). Normally I advise people to create their Excel charts at the size they want the chart after pasting into another application. This might be a case where I'd suggest you create your charts in Excel at a different size than their ultimate size in PowerPoint. Make them 2 or 3 times their final size, paste as pictures in PowerPoint, and rescale them there. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Mardi Caulfield wrote: I'm pasting bar charts (as pictures) into powerpoint slides. (around 300 of them). The charts are EXTREMELY tiny - font size 3pt (autoscale off!) - i've run the excel gauntlet with axis truncating, fonts distorting etc. and have found fixes for most of it. (after 300 charts, my aunt's cat would have found it!) The bars (when they are correctly sized, are 1mm wide) HOWEVER - one tiny (and potentially project flooring) glitch remain beyond my reach: The bars, once pasted, are completely irregular sizes - some as small as 0.3mm - in the same graph! Soooooo - I have been forced to (wait for this) UNGROUP each chart on the slide, and then MANUALLY select each bar ( ehm, 1,800 of them) and change the size to 1mm!! I've worked on this for around 14 hours. I'm tired. I would so very much like some help. From someone. Please? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Font size changes in Excel 2003 charts when re-opened | Lucie Harris | General Discussion | 0 | June 16th, 2004 05:52 AM |
How to Make Pie Charts the Same Size | Jon Peltier | Charts and Charting | 0 | May 3rd, 2004 09:34 PM |
Comparing a set of charts according to the size of each chart | Hassan Alameh | Charts and Charting | 1 | March 5th, 2004 01:05 PM |
Pie Charts Vary In Size | DaveK | Charts and Charting | 1 | December 4th, 2003 05:33 PM |