register for free
View our sister sites
Our sister sites
Our sister sites
Our sister sites
Lel
Dogsey Veteran
Lel is offline  
Joined: May 2004
Posts: 7,930
Female 
 
13-05-2005, 12:41 PM

Excel help needed!!!!

I havent used Excel to produce graphs and charts etc for ages but need a bit of help if anyone knows anything about it (pleeeeeeeeeeeease before I cry).

Right I have produced the chart I want with all the relevant info on (after much twiddling and swearing) but how the hell do I get it to reduce in size?
Its for my project and I dont want pages and pages of charts- I want to be able to have a couple (or three) charts on the same page but I either get them too tiny to read or half the info is chopped off.

I am about to go into a quiet corner and cry now- :smt010

can any clever dogwebbers help?????
Reply With Quote
Het
Dogsey Veteran
Het is offline  
Location: Eden Valley,Cumbria
Joined: Mar 2005
Posts: 3,158
Female 
 
13-05-2005, 01:36 PM
Hi Lel

Have you tried copying the chart and pasting it into word, then you can state what size you want it to be, and you can fit as many as you like on a page
Reply With Quote
leo
Dogsey Veteran
leo is offline  
Location: Long Eaton
Joined: Oct 2004
Posts: 12,868
Male 
 
14-05-2005, 09:03 PM
Here you go Lel

Resize a diagram or organization chart
Click the diagram or organization chart and do any of the following:

If you want to resize a diagram or organization chart along with the space around it within the drawing, drag the sizing handle at the corner of the drawing to the size you want.
If you want to make the border around the drawing closely fit the diagram, on the Diagram or Organization Chart toolbar, click Layout, and then click Fit Diagram to Contents or Fit Organization Chart to Contents.
If you want to add space around the diagram within the drawing, on the Diagram or Organization Chart toolbar, click Layout, and then click Expand Diagram or Expand Organization Chart.

hope this helps
Reply With Quote
Lel
Dogsey Veteran
Lel is offline  
Joined: May 2004
Posts: 7,930
Female 
 
15-05-2005, 10:54 AM
Thanks Leo and Het

As I say its ages since Ive done any charts etc and when I used chart wizard it came up as a book or something on the page with the info on (before it was a chart) and when i right clicked it didnt give me the option to save to word (or anywhere)

I will try that Leo thankyou
Reply With Quote
leo
Dogsey Veteran
leo is offline  
Location: Long Eaton
Joined: Oct 2004
Posts: 12,868
Male 
 
16-05-2005, 03:41 PM
Did it work Lel
Reply With Quote
Lel
Dogsey Veteran
Lel is offline  
Joined: May 2004
Posts: 7,930
Female 
 
16-05-2005, 03:48 PM
I was looking for this post earlier to say thankyou

Yes it did work- I now have 5 small graphs saved into my document- thanks Leo

Easy when you know how isnt it lol

Reply With Quote
leo
Dogsey Veteran
leo is offline  
Location: Long Eaton
Joined: Oct 2004
Posts: 12,868
Male 
 
16-05-2005, 09:21 PM
Good glad i could help
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools


© Copyright 2016, Dogsey   Contact Us - Dogsey - Top Contact us | Archive | Privacy | Terms of use | Top