Skip to content
ProjectControls.com
Planning, Scheduling & Programming Discussion

Excel Histograms

In the Open Standard
Alex CostarasMember for 21 years 4 months
Created
4
2
0
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?
Save Follow Follow forum Report
Reply New topic

4 replies

Oldest first
  1. 0
    Razi Khan ·
    #1
    Hi Alex

    Please check the following steps

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

    Hope this will solve your problem.

    Cheers
    Report
  2. 0
    Sukumaran Subaramaniyan ·
    #2
    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.
    Report
  3. 0
    Sukumaran Subaramaniyan ·
    #3
    Hi Razi,

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

    Cheers!!!
    Report
  4. 0
    Alex Costaras ·
    #4
    Thanks Razi that did the trick
    Report

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Log inJoin free

Existing members: your original username and password still work. Forgot password?