J
Jim@Tech
I'm migrating some old files from several sites and want to show progress
against three criteria (Number of sites migrated, number of files removed and
size of files removed). This is fairly straightforward as I simply plot the
number achieved against the number remaining to get a stacked bar for all
three criteria.
My problem is that I need to show the planned progress on each bar (e.g. in
week 3 we have migrated 3 sites but had planned to migrate 4) as a line on
each bar.
Reading through the forum, I can do this by plotting a stacked column and
then changing the 'target' series to a Line chart rather than a stacked
column, however I then get a line that joins the three target values, and I
just want a line across each column in the appropriate place.
Also, I'd prefer to plot the data horizonatally as a stacked bar rather than
a stacked column, but when I plot the data as a stacked bar and change the
Target series to a line chart, ths points are plotted against the Y axis
instead of the X axis, and there doesn't seem to be an option to change them
to the X axis.
I'm doing this in Excel 2002 and here's the data I'm using:
Achieved Remaining Planned
# sites migrated 3 45 4
Disk Space saved (GB) 94.6 1291.15 85
# files removed 350 9649 350
Does anyone know if this is possible please?
Many thanks.
against three criteria (Number of sites migrated, number of files removed and
size of files removed). This is fairly straightforward as I simply plot the
number achieved against the number remaining to get a stacked bar for all
three criteria.
My problem is that I need to show the planned progress on each bar (e.g. in
week 3 we have migrated 3 sites but had planned to migrate 4) as a line on
each bar.
Reading through the forum, I can do this by plotting a stacked column and
then changing the 'target' series to a Line chart rather than a stacked
column, however I then get a line that joins the three target values, and I
just want a line across each column in the appropriate place.
Also, I'd prefer to plot the data horizonatally as a stacked bar rather than
a stacked column, but when I plot the data as a stacked bar and change the
Target series to a line chart, ths points are plotted against the Y axis
instead of the X axis, and there doesn't seem to be an option to change them
to the X axis.
I'm doing this in Excel 2002 and here's the data I'm using:
Achieved Remaining Planned
# sites migrated 3 45 4
Disk Space saved (GB) 94.6 1291.15 85
# files removed 350 9649 350
Does anyone know if this is possible please?
Many thanks.