switching axis

[Guest]

How do I switch the Y axis values so they show in the X axis and vice-a-versa?
Example: I want to create chart showing dates on the X axis and my
categories on the Y axis. Basically, I want to create a timeline based off
of my table that has one column of different events and another column
showing the dates they took place. Is this possible?

 

[Debra Dalgleish]

You can use a gantt chart to show the timelines. Jon Peltier has links
to sites with instructions:

http://www.peltiertech.com/Excel/Charts/GanttLinks.html