Results 1 to 8 of 8
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    austin, Texas, USA
    Posts
    1,029
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Multi-Valued Bar Chart (Excel 2003, Off Prof 2003)

    This should be doable but I can't seem to get it to work... I have a set of data where each category has a pos, neg, N/A value with a count on each. i want to generate a chart with three bars per category and color-coded as pos: green; neg: red; N/A: black. each bar should display the count for the value and each range of bars should, ideally, have a single label for the span.

    i can get a chart by faking it but would like to make it happen automatically. i messed with defining different series-es, but not succeeding at present.

    TIA

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Multi-Valued Bar Chart (Excel 2003, Off Prof 2003)

    Do you mean something like this?
    Attached Files Attached Files
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    austin, Texas, USA
    Posts
    1,029
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Multi-Valued Bar Chart (Excel 2003, Off Prof 2

    yup

  4. #4
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Multi-Valued Bar Chart (Excel 2003, Off Prof 2

    Good. <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
    Regards,
    Rory

    Microsoft MVP - Excel

  5. #5
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    austin, Texas, USA
    Posts
    1,029
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Multi-Valued Bar Chart (Excel 2003, Off Prof 2

    well, i think this has to do with my on-going struggle with understanding pivot tables. the data is from Access and it's not always the case that there are three values for each pos/neg/neut. so i have to move stuff around.

  6. #6
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Multi-Valued Bar Chart (Excel 2003, Off Prof 2

    As long as you have at least one positive, one negative and one neutral, you should get a column for each in your pivot table (I am guessing as to your data structure though).
    Regards,
    Rory

    Microsoft MVP - Excel

  7. #7
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    austin, Texas, USA
    Posts
    1,029
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Multi-Valued Bar Chart (Excel 2003, Off Prof 2

    that's not always the case, but i am not going to worry about it. thanks for the response - i thought it was an easy one!

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Multi-Valued Bar Chart (Excel 2003, Off Prof 2

    If you're using a crosstab query in Access, you can specify the Column Headings property of the query. If you do, the query will always have the specified columns, regardless of whether they actually occur in the data.

Posting Permissions

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