Results 1 to 2 of 2

GRAPH - 2 stacked bars under one heading

This is a discussion on GRAPH - 2 stacked bars under one heading within the Excel Questions forums, part of the Question Forums category; Hi all, Graph's are not my strong point. I have a set of data. Territory as my x axis and ...

  1. #1
    New Member
    Join Date
    Dec 2015
    Posts
    9

    Default GRAPH - 2 stacked bars under one heading

    Hi all,

    Graph's are not my strong point.

    I have a set of data. Territory as my x axis and revenue as y. Using a stacked graph the revenue can be split out by business stream.

    What ideally i'm trying to do is put UK as a main x axis, then have 2015 as one bar and 2016 next to it. Which will then be stacked by stream, same as before.

    Does anyone know how to do this, or if its possible. I find excel a bit limiting with graphs or it may just be me .

    Any suggestions would really help.

    Leigh

  2. #2
    Board Regular pbornemeier's Avatar
    Join Date
    May 2005
    Location
    Virginia Beach, VA USA
    Posts
    3,312

    Default Re: GRAPH - 2 stacked bars under one heading

    This technique may give you what you want: Clustered and Stacked Column and Bar Charts - Peltier Tech Blog
    Phil

    - Use CODE tags to keep your code formatted. See: BB Tags
    - How to attach Screenshots
    - Try searching for your answer first, see how
    - Test and validate results for all code on a copy of your worksheet!! How do you use the code you just found?
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com