Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 84
Default Timeline Chart, but not a Gantt

Hi, I want to make a stacked bar chart with the following data:

Tasks Start Date End Date Duration
Phase I 01-Jul-08 01-Mar-09 243
Phase II 01-Jul-08 01-Jul-10 730
Phase III 01-Jan-10 01-Mar-10 59
Phase IV 01-Jul-09 01-Jul-11 730

The Y axis are dates, at monthly intervals. It is supposed to start with
July '08 and ending with July '11.

I have hidden the axis labels for X (the phase), but have put the data label
with the bar of each phase.

So, the graph has the dates along the top, and within the chart are
different color bars representing each phase. The phases are not dependent
upon each other.

The Problem:
On the chart at the left (where the lowest dates are) it Shows July 2008
twice. And, at the far right (where the highest dates are) it stops before
it reaches the end June (it should go to july). I have tried manually
changing the scale to set the start and end dates, but it doesn't change.

Also, because the chart has two July 1, 2008 values, this date is showing up
twice on the timeline scale.

AND, none of the bars are long enough. They end before they reach the date
the phase is to finish.

I'm betting I'm doing something fundamentally wrong with the chart. If
there are ideas about how I can fix it - I'm open to suggestions!

Thanks!
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Timeline Chart Urgent question regarding LIST[_2_] Charts and Charting in Excel 1 March 22nd 08 07:15 PM
timeline in line chart Nmeyer Charts and Charting in Excel 1 January 20th 08 10:14 PM
Timeline Chart? PaulW Excel Discussion (Misc queries) 2 December 18th 07 06:25 AM
timeline chart jtaiariol Excel Worksheet Functions 0 June 20th 07 06:39 PM
Timeline Chart? ckrogers Charts and Charting in Excel 3 March 17th 05 09:20 PM


All times are GMT +1. The time now is 04:31 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"