Results 1 to 5 of 5

Stacked column graph with colours AND divisions

Threaded View

  1. #1
    Registered User
    Join Date
    09-27-2011
    Location
    Eastbourne, England
    MS-Off Ver
    Excel 2002
    Posts
    3

    Stacked column graph with colours AND divisions

    Is there any way to present the following CSV dataset in Excel as a stacked column graph with:

    + a column for each customer name
    + colour-coded by product category
    + divided up to show each order value (this is the bit that I can't do!)

    CustomerName,ProductCategory,OrderValue
    Aardvark,Software,£100
    Aardvark,Hardware,£200
    Aardvark,Hardware,£300
    Microsoft,Software,£20
    Microsoft,Software,£20
    Microsoft,Hardware,£300

    Microsoft Paint mockup attached!
    Attached Images Attached Images

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