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


R

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
 
Ad

Advertisements

T

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
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top