L
Laura C
Can anyone please offer any solutions to my problems:
What I want is a chart to show several milestones and key
activities.
What I envisage is the following: the x-axis 'time', the y-
axis 'milestone number', the milestone shown as a bar (i.e
the x-axis runs from Jan 04 through to Dec 07) and if
target date for milestone is Apr 06 then this is where the
bar will stretch to. Overlying the bar I want to show key
activities (i.e. Plan written, Contract agreed etc) I'd
like to show these just as diamonds.
Ideally I'd like it all on one chart, but I just don't
know what chart to use and if there is one that is capable
of having both types???
If this is not possible does anyone know how to solve this
problem?
What I have in place at the moment is a bar chart (x-
axis 'time', y-axis 'milestone name'-linked to sheet) and
then an X-Y Scatter pasted on top (x-axis 'time' but y-
axis just a number (not shown on chart), I can't select
the names as y-axis??)). Problem is that the source data
for the charts varies dependent on what the category the
user selects from a front sheet (a category is selected
and data filtered) therefore as the number of characters
in the milestones names varies the plot area of the bar
chart varies and the second chart I have pasted on top
remains the same size so therefore my scale is out.
Is there anyway to fix the chart plot area of both so that
the scales won't keep getting out of scynch with each
other? Or somehow get the x-y scatter to have the y-axis
as milestone names, therefore both charts will vary to the
same size??
I know that it might sound confusing so if I've clumbsily
described something and you need it clarified please just
ask.
Cheers
Laura
What I want is a chart to show several milestones and key
activities.
What I envisage is the following: the x-axis 'time', the y-
axis 'milestone number', the milestone shown as a bar (i.e
the x-axis runs from Jan 04 through to Dec 07) and if
target date for milestone is Apr 06 then this is where the
bar will stretch to. Overlying the bar I want to show key
activities (i.e. Plan written, Contract agreed etc) I'd
like to show these just as diamonds.
Ideally I'd like it all on one chart, but I just don't
know what chart to use and if there is one that is capable
of having both types???
If this is not possible does anyone know how to solve this
problem?
What I have in place at the moment is a bar chart (x-
axis 'time', y-axis 'milestone name'-linked to sheet) and
then an X-Y Scatter pasted on top (x-axis 'time' but y-
axis just a number (not shown on chart), I can't select
the names as y-axis??)). Problem is that the source data
for the charts varies dependent on what the category the
user selects from a front sheet (a category is selected
and data filtered) therefore as the number of characters
in the milestones names varies the plot area of the bar
chart varies and the second chart I have pasted on top
remains the same size so therefore my scale is out.
Is there anyway to fix the chart plot area of both so that
the scales won't keep getting out of scynch with each
other? Or somehow get the x-y scatter to have the y-axis
as milestone names, therefore both charts will vary to the
same size??
I know that it might sound confusing so if I've clumbsily
described something and you need it clarified please just
ask.
Cheers
Laura