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!
Bookmarks