100% Stacked Chart

[John Bates]

Hi,

I am having trouble figuring out how to create a 100% stacked chart. In the attached file, I want two 100% stacked charts (1 for Inputs and 1 for Optimal) and then I want the sections for each stacked chart be represented by each Media Channel (Catalog, Radio, etc.). Any help?

Thank you so much !!
John

[teylyn]

Hello,

- select B3:D17
- click Insert ribbon > Column > 100% Stacked Column
- click Switch Row/Column in the Data group of the Design tab

cheers,

[John Bates]

Perfect, thanks!! I didn't know about the switch rows/columns.