+ Reply to Thread
Results 1 to 3 of 3

mixing column chart types for series and macro series?

  1. #1
    Forum Contributor
    Join Date
    09-23-2008
    Location
    Rhode Island
    MS-Off Ver
    Excel for Mac 2011 and 2007 on PC
    Posts
    265

    mixing column chart types for series and macro series?

    I'm trying create a cluster column chart but have each column in the cluster a stacked column, so essentially I have two sets of series. The series want to make up the stacked column and then I want to be able to have the two sets show up as cluster columns across a range of nominal topics (in this case it is town budgets for a number of towns with two different assumptions of state funding, so the stacked columns show the balance of funding between the state, town and feds, and the the cluster columns show two different budgetary scenarios under consideration).

    Don't know if this is something I can implement as a custom user defined chart style or . . .

    Thanks for any hints.

    Brian

  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: mixing column chart types for series and macro series?

    maybe have a look here

    http://peltiertech.com/WordPress/clu...column-charts/

  3. #3
    Forum Contributor
    Join Date
    09-23-2008
    Location
    Rhode Island
    MS-Off Ver
    Excel for Mac 2011 and 2007 on PC
    Posts
    265

    Re: mixing column chart types for series and macro series?

    Quote Originally Posted by teylyn View Post
    thanks. that's clever. of course, set up enough series to cover all your indecies and then 0 some in every other category and voila.

    So, my next question is on chart formatting. Is there a leading or spacing function in the formatting so I can get the Axis titles to move a little bit along the axis which will make it clearer which bars they are associated with.

    I find an alignment which allos me to change their angle to the axis. I tried chosing subscript in the font function hoping that would physically drop the type a little bit, but no dice. The type didn't move, although it got smaller.

    any ideas?

+ 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