What chart can I use?


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
 
Ad

Advertisements

Ad

Advertisements

L

Laura C

It would be the best solution, unfortunately our company
IT suppliers aren't the best therefore not everyone has MS
Project on their PC, and it's a multi-user application on
a network. So can't use Project as there will be users who
won't be able to use it.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top