Link to home
Start Free TrialLog in
Avatar of Edward Pamias
Edward PamiasFlag for United States of America

asked on

Excel Stackable Columns

I know someone here can figure this out in 2 seconds. I need to chart the info in the attached sheet. When I do it the names show up on the legend, but I need the ticket types to be on the legend.

Thanks in advance for your assistance!
sample.xlsx
ASKER CERTIFIED SOLUTION
Avatar of terencino
terencino
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
In Outlook 2010...if you double click the resulting chart...it should take you to the "Design ribbon".

Then just click the "Switch Row / Column Data" button.

Should work.
Avatar of Edward Pamias

ASKER

Thanks to the first 2 who assisted. I split up the points one for giving me the instructions on how to do it and the other for updating the sample sheet.
Ha it was the same guy, I sent the sheet then remembered to send to how-to!
Thanks for the grade!
So much for scoring my first points.  :(   Next time...  Good...quick answer! :)