+ Reply to Thread
Results 1 to 3 of 3

Clustered Column Chart Help

  1. #1
    Registered User
    Join Date
    08-18-2008
    Location
    Manila
    MS-Off Ver
    Office 2003, Office 2007
    Posts
    26

    Clustered Column Chart Help

    Hi All,

    I am doing a clustered column chart. But the chart won't display all the items in the first cluster. See screenshot. Are there settings of the chart I should change to display all the items for the first cluster to display?

    Thanks,
    Attached Images Attached Images
    Last edited by LordMarcus; 03-19-2009 at 12:25 AM. Reason: Forgot to include attachement

    __________
    LordMarcus

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Clustered Column Chart Help

    Hi,

    format your x axis:

    On the Scale tab tick the box "Value (Y) axis crosses between categories". This is the third box from the bottom

    Cheers

  3. #3
    Registered User
    Join Date
    08-18-2008
    Location
    Manila
    MS-Off Ver
    Office 2003, Office 2007
    Posts
    26

    Re: Clustered Column Chart Help

    Wow! It's pretty simple! Many thanks, Teylyn.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1