• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 278
  • Last Modified:

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
0
Edward Pamias
Asked:
Edward Pamias
  • 3
  • 2
2 Solutions
 
terencinoCommented:
How about this?
sample.xlsx
0
 
terencinoCommented:
The trick was to right click on the chart, Select Data ... > Switch Row/Colum

Let me know if any issue
...Terry
0
 
James PowellData Analyst / Online Retail DevelopmentCommented:
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
Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

 
Edward PamiasTeam Lead RRS DeskAuthor Commented:
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
 
terencinoCommented:
Ha it was the same guy, I sent the sheet then remembered to send to how-to!
Thanks for the grade!
0
 
James PowellData Analyst / Online Retail DevelopmentCommented:
So much for scoring my first points.  :(   Next time...  Good...quick answer! :)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now