+ Reply to Thread
Results 1 to 2 of 2

Clustered Bar Chart

  1. #1
    Registered User
    Join Date
    08-08-2012
    Location
    PA
    MS-Off Ver
    Excel 2010
    Posts
    7

    Clustered Bar Chart

    Excel 2010.
    I have 3 separate measures to plot as a cluster, for several products, for several time periods.
    All works well except I cannot see a way to display the products name. It seems that on the bottom axis I can show the time period only.
    Do I have to rig this to concatenate both product name and month name as a single column ?
    Also, strangely, the category legend includes the products name...which is incorrect.
    I had to include the products as the 1st data series in order to get the clustering effect.
    Anyone experience something like this ?
    When I attempted this as a pivotchart, I got closer. They key is the multilevel Category labels setting.
    In the case of the pivotchart, the second level was obliterated. I have no idea how to control that as the settings for rotation, etc. seem only to apply to the first level.
    Last edited by syswizard; 08-13-2012 at 04:38 PM.

  2. #2
    Registered User
    Join Date
    08-08-2012
    Location
    PA
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: Clustered Bar Chart

    Strangely, unsetting "Autoformat" on the horizontal axis solved the problem partially.
    Now I can expand that axis and see the axis labels. Strangely, Autoformat should have done this correctly...or at least much better than it did.
    So that's a bug.

    However, now the secondary axis does not align with the data points properly along the upper part of the chart.
    This is a bug. I was using a clustered column pivot chart. I tried everything to make this work....for naught.
    Last edited by syswizard; 08-14-2012 at 01:48 PM.

+ 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