Create stacked bar chart - two values per column with multiple columns

pigsfoot

New Member
Joined
Dec 13, 2007
Messages
47
Hi,
I'm trying to create a stacked chart which will include two values per day ( each day being its own column. ( the two values need to be stacked on top of each other ) but for the life of me i can't seem to format it properly. I can get one stack for one day with the two values but if i add additional days data it add everything into the same stack?

Attached is an image of the data. Can anyone point me in the right direction please

Thanks in advance
 

Attachments

  • Capture.JPG
    Capture.JPG
    44.8 KB · Views: 4

Some videos you may like

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

GraH

Well-known Member
Joined
Mar 22, 2020
Messages
613
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
Hello,
I guess a simple stacked chart works, if you turn your data a bit upside down.
1599383172097.png
 

Watch MrExcel Video

Forum statistics

Threads
1,112,782
Messages
5,542,486
Members
410,556
Latest member
rebecamuresan
Top