A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Bar charts - bars irregular size



 
 
Thread Tools Display Modes
  #1  
Old September 25th, 2004, 08:55 AM
Mardi Caulfield
external usenet poster
 
Posts: n/a
Default 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  
Old September 25th, 2004, 06:27 PM
Jon Peltier
external usenet poster
 
Posts: n/a
Default

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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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 02:05 PM
Pie Charts Vary In Size DaveK Charts and Charting 1 December 4th, 2003 06:33 PM


All times are GMT +1. The time now is 09:47 AM.


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