Consulting

Results 1 to 4 of 4

Thread: Sleeper: Charting question

  1. 01-23-2007, 06:23 PM #1
    peacenik
    peacenik is offline
    VBAX Regular
    Joined
    Jun 2005
    Location
    Sydney
    Posts
    60
    Location

    Sleeper: Charting question

    This is not really a VBA question, but I am hoping that someone here might be able to help me.

    I have data for two lines of business across two years and across several states.

    I would like to build a Bar chart showing the two lines of business stacked and comparing year on year next to each other with the states displayed across the x axis.

    Some sample data is in the attached file.
    Reply With Quote Reply With Quote
  2. 01-24-2007, 05:31 AM #2
    d4vem
    d4vem is offline
    VBAX Regular
    Joined
    May 2006
    Posts
    67
    Location
    Take a look at the attachment. Is this what you are looking for.
    Reply With Quote Reply With Quote
  3. 01-24-2007, 02:22 PM #3
    peacenik
    peacenik is offline
    VBAX Regular
    Joined
    Jun 2005
    Location
    Sydney
    Posts
    60
    Location
    Thanks for your help, but no, that is not what I want. I wouild like to stack Product A and Product B, so that they can be compared year on year for each state.
    Reply With Quote Reply With Quote
  4. 01-24-2007, 02:44 PM #4
    mdmackillop
    mdmackillop is offline
    Administrator
    VP-Knowledge Base     VBAX Grand Master mdmackillop's Avatar
    Joined
    May 2004
    Location
    Scotland
    Posts
    14,489
    Location
    More like this?
    MVP (Excel 2008-2010)

    Post a workbook with sample data and layout if you want a quicker solution.

    To help indent your macros try Smart Indent

    Please remember to mark threads 'Solved'
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules