Blue_Bunny
09-08-2011, 11:41 AM
Hi All,
Once again - I am rather embarrassed that I am making this post ...
I would like to make a line or xy chart where each series represents a separate project. I would like the lines to intersect at points where dates at shared milestones are the same. I would like to have dates on the horizontal or X-Axis and plan to hide the vertical or Y-axis.
I've attach an example file and also tried to reproduce what I see on this link with no luck:
http://peltiertech.com/Excel/ChartsHowTo/CatVsValueAxis.html
I would like to reproduce the chart with one of the data sets in the example file. The file also contains a working version of a simple line chart (of what I want), but the date data will not be in the same format as what I need to chart, so I'm seeking an alternative solution (that uses data set 1, 2 or 3).
Thanks in advance!
BB
Once again - I am rather embarrassed that I am making this post ...
I would like to make a line or xy chart where each series represents a separate project. I would like the lines to intersect at points where dates at shared milestones are the same. I would like to have dates on the horizontal or X-Axis and plan to hide the vertical or Y-axis.
I've attach an example file and also tried to reproduce what I see on this link with no luck:
http://peltiertech.com/Excel/ChartsHowTo/CatVsValueAxis.html
I would like to reproduce the chart with one of the data sets in the example file. The file also contains a working version of a simple line chart (of what I want), but the date data will not be in the same format as what I need to chart, so I'm seeking an alternative solution (that uses data set 1, 2 or 3).
Thanks in advance!
BB