Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Value (Y) axis crosses between categories and Secondary Value (Y) Axis | Charts and Charting in Excel | |||
Time Series Chart Data Plot Line ''Disappears'' When Y Axis Formating Is Changed | Charts and Charting in Excel | |||
Secondary y-axis for certain x-axis categories (not by series) | Charts and Charting in Excel | |||
How do I plot multiple x-axis series in excel charts | Charts and Charting in Excel | |||
how do I get the x-axis to plot values rather than categories in . | Charts and Charting in Excel |