Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Excel Histograms

4 replies [Last post]
Wed, 2005-06-08 12:30
Alex Costaras
User offline. Last seen 7 years 48 weeks ago. Offline
Joined: 30 May 2005
Posts: 13
Groups: Petro-Chem / Oil & Gas
I having a major headache trying to produce a histogram with excel version 2003. I’ve got two columns of figures 1st column are dates (01-mmm-yy) second column is the histogram value. When using the wizard, the generated histogram (Column clustered) has no width. It is just a pencil line in thickness. Changing the overlap and Gapwidth under format data series; options has no impact the column always remains pencil line thick. Anyone got any ideas. Is there a known bug with this version of Excel?
Top

Replies

Thu, 2005-06-09 08:31
#1
Alex Costaras
User offline. Last seen 7 years 48 weeks ago. Offline
Joined: 30 May 2005
Posts: 13
Groups: Petro-Chem / Oil & Gas
Thanks Razi that did the trick
Top
Thu, 2005-06-09 01:42
#2
Sukumaran Subaram...
User offline. Last seen 8 years 40 weeks ago. Offline
Joined: 2 Mar 2005
Posts: 229
Groups: GPC Malaysia
Hi Razi,

Look like we sent the thread almost at the same time.

Cheers!!!
Top
Thu, 2005-06-09 01:37
#3
Sukumaran Subaram...
User offline. Last seen 8 years 40 weeks ago. Offline
Joined: 2 Mar 2005
Posts: 229
Groups: GPC Malaysia
Hi,

Check the following items:
1)X axis scale
2)Font size
3)Text alignment
Upon the above changes increase the chart area size. This will increase the histogram width.

Regards.
Top
Thu, 2005-06-09 01:35
#4
Razi Khan
User offline. Last seen 7 years 30 weeks ago. Offline
Joined: 17 Jun 2004
Posts: 74
Groups: None
Hi Alex

Please check the following steps

Format Axis(Months)>Scale
Make Minor Unit = Months

Hope this will solve your problem.

Cheers
Top