Plot a time series on the x-axis and categories on the y-axis

[rmellison]

Hi,

I have data from a Communication plan which I want to show graphically, to
show when each stakeholder category begins its engagement.

I want to plot data with a time series (mmm-yy) on the x-axis, then a range
of stakeholders (text) on the y-axis, with a point on the chart showing when
each stakeholder starts its Comms.

I'm having some trouble getting any charts in Excel to show data in this
way. I can do it flipped round - with time on the y- and categories on the
x-axis - but I specifically want the time series on the X-axis.

Any advice would be great. Unfortunately I can't send any sample data.

Thanks,
Roger

 

[rmellison]

Forgot to say, I'm using Excel 2003 on WinXP SP2.

 

[Tushar Mehta]

You might want to look at how to create a Gantt chart. Look at the below or
search Google.

Using a Worksheet for a Gantt Chart - I
http://www.tushar-mehta.com/excel/newsgroups/worksheet_as_chart/worksheet_as_gantt_chart.htm

Gantt (Project) chart
http://www.tushar-mehta.com/excel/software/ganttchart/

--
Tushar Mehta
http://www.tushar-mehta.com
Custom business solutions leveraging a multi-disciplinary approach
In Excel 2007 double-click to format may not work; right click and select
from the menu

 

[Jon Peltier]

Here's more about Gantts in Excel:
http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=343
http://peltiertech.com/Excel/Charts/GanttChart.html

- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/>
Advanced Excel Conference - Training in Charting and Programming
http://peltiertech.com/Training/2009-06-ACNJ/AdvExcelConf200906ACNJ.html
_______