Solved

Excel Stackable Columns

Posted on 2013-01-18
6
263 Views
Last Modified: 2013-01-18
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
0
Comment
Question by:Edward Pamias
  • 3
  • 2
6 Comments
 
LVL 16

Accepted Solution

by:
terencino earned 500 total points
ID: 38795046
How about this?
sample.xlsx
0
 
LVL 16

Assisted Solution

by:terencino
terencino earned 500 total points
ID: 38795054
The trick was to right click on the chart, Select Data ... > Switch Row/Colum

Let me know if any issue
...Terry
0
 
LVL 1

Expert Comment

by:James Powell
ID: 38795060
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.
0
Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 
LVL 14

Author Closing Comment

by:Edward Pamias
ID: 38795071
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.
0
 
LVL 16

Expert Comment

by:terencino
ID: 38795086
Ha it was the same guy, I sent the sheet then remembered to send to how-to!
Thanks for the grade!
0
 
LVL 1

Expert Comment

by:James Powell
ID: 38795124
So much for scoring my first points.  :(   Next time...  Good...quick answer! :)
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Article by: Leon
Software Metering within our group of companies has always been an afterthought until auditing of software and licensing became a pain point. Orchestrator and SCCM metering gave us the answer and it was an exciting process.
Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

706 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now