graphs resizing themselves

Mar 7th, 2002, 05:28 AM

Pls help!! I am an Excel novice and trying to produce a report for work. It's looking pretty good, but my graphs keep resizing themsleves so that they are either tiny or massive - the data labels also tend to resize to font point 1 or other times point 42. I save after every time and the data sources are all contained within the same spreadsheet - any auseful advice for me???

LaDonnaYoung · Mar 27th, 2002, 10:48 AM

I am having the same problem. If you get an answer please let me know. I will let you know if I find one.
My e-mail is FINANCE@ISMSYS.com
Put My Name in the Subject.

Thank You

knilja · Oct 12th, 2004, 04:01 PM

I noticed no one has responded to your questions but I too am a self-taught and novice graph (chart) person. Although I feel I am an intermediate Excel user, I am getting stumped on this problem. I have created several charts using the "canned" ones. Specifically the Bars or the Bars with lines. The problem is sometimes I've created my graph and I've got 4 weeks of data with only 3 bars of data per week and the bars are so thin you can hardly see the color to tell what they are on the legend. There is obviously plenty of room on the chart for them to widen and I have searched and tried everything but I can't figure it out. I'm turning this in for my job and would sure appreciate someones help.
Thank you.

Doreen · Feb 28th, 2005, 02:36 PM

I have this problem, too. This has helped it somewhat, but not always. Turn off the auto-scale option in the "format axis" command and the "font" tab.

Oct 12th, 2004, 04:01 PM	#3
knilja New Member Join Date: Oct 2004 Posts: 2	Re: graphs resizing themselves I noticed no one has responded to your questions but I too am a self-taught and novice graph (chart) person. Although I feel I am an intermediate Excel user, I am getting stumped on this problem. I have created several charts using the "canned" ones. Specifically the Bars or the Bars with lines. The problem is sometimes I've created my graph and I've got 4 weeks of data with only 3 bars of data per week and the bars are so thin you can hardly see the color to tell what they are on the legend. There is obviously plenty of room on the chart for them to widen and I have searched and tried everything but I can't figure it out. I'm turning this in for my job and would sure appreciate someones help. Thank you.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 7th, 2002, 05:28 AM	#1
Guest Posts: n/a	Pls help!! I am an Excel novice and trying to produce a report for work. It's looking pretty good, but my graphs keep resizing themsleves so that they are either tiny or massive - the data labels also tend to resize to font point 1 or other times point 42. I save after every time and the data sources are all contained within the same spreadsheet - any auseful advice for me???

Mar 27th, 2002, 10:48 AM	#2
LaDonnaYoung New Member Join Date: Mar 2002 Posts: 1	I am having the same problem. If you get an answer please let me know. I will let you know if I find one. My e-mail is FINANCE@ISMSYS.com Put My Name in the Subject. Thank You

Feb 28th, 2005, 02:36 PM	#4
Doreen New Member Join Date: Sep 2004 Location: Portland, ME Posts: 9	I have this problem, too. This has helped it somewhat, but not always. Turn off the auto-scale option in the "format axis" command and the "font" tab.