Solved

Excel Stackable Columns

Posted on 2013-01-18
6
265 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
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 
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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
Outlook Free & Paid Tools
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

920 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

14 Experts available now in Live!

Get 1:1 Help Now