If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Plot a time series on the x-axis and categories on the y-axis
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 |
#2
|
|||
|
|||
Plot a time series on the x-axis and categories on the y-axis
Forgot to say, I'm using Excel 2003 on WinXP SP2.
"rmellison" wrote: 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 |
#3
|
|||
|
|||
Plot a time series on the x-axis and categories on the y-axis
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/ne...antt_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 "rmellison" wrote: 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 |
#4
|
|||
|
|||
Plot a time series on the x-axis and categories on the y-axis
Here's more about Gantts in Excel:
http://pubs.logicalexpressions.com/P...cle.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...00906ACNJ.html _______ "rmellison" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|