You've more or less answered your own question. Think about it this
way and it applies irrespective of the program you use. Even if you
had a monitor that showed 1,400 pixels horizontally the 700 elements
you want to show limit each element to be only 2 pixels wide!
One option you haven't mentioned is to summarize the tasks into
functionally meaningful groups and show the groups in a high-level
chart. Each group can then be individually shown in a chart by
itself.
So, your choices are show a chart that is essentially undecipherable,
use a mammoth chart, remove some elements, or summarize the data into
groups.
On Tue, 18 Nov 2008 16:16:00 -0800, Jennifer
wrote:
I have create a gantt chart with three series, which is possible to
do,
however I have about 700 rows to chart, which makes the chart
unreadable
unless mammoth in size. Any sugestions ,besides the obvious of not
charting
some of the data.
I am need to report each event for a YTD period to show cycle time
change.
Is there perhaps another chart type?
Regards,
Tushar Mehta
Microsoft MVP Excel 2000-2008
www.tushar-mehta.com
Tutorials and add-ins for Excel, PowerPoint, and other products