Solved

Excel Stackable Columns

Posted on 2013-01-18
6
270 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 18

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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

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.
This article describes how to import an Outlook PST file to Office 365 using a third party product to avoid Microsoft's Azure command line tool, saving you time.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

724 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