Solved

Excel Stackable Columns

Posted on 2013-01-18
6
266 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
Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
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

Title # Comments Views Activity
Hiding information in Excel 16 70
Select only certain columns not entire sheet 12 26
outlook 365  Desktop Alert 6 33
Excel lookup tables & values 7 24
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

813 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

17 Experts available now in Live!

Get 1:1 Help Now