displaying data within column
 

hi there i'm having alot of trouble trying to display data within a
column.

here is a screenshot of what i am doing:

'[img=http://img363.imageshack.us/img363/6720/graph2vr.th.jpg]'
(http://img363.imageshack.us/my.php?image=graph2vr.jpg)

the x axis is phase so each column in the graph are phases. the y axis
is time - how long each phase lasts.

but within each of the phases (columns) i would like to display data,
the final data column in the spreadsheet - "% of cost in phase". so the
phase (column) is broken down into its deliverables (the 2nd data column
in spreadsheet) according to % cost in phase (final data column in
spreadsheet)

i have been searching through the newsgroup and forum.. though the data
i want to display within the column does not relate to the y axis so a
stacked graph isn't what i am after..

any help would be greatly appreciated.. thank you!
peter


--
iconic83
------------------------------------------------------------------------
iconic83's Profile: http://www.excelforum.com/member.php...o&userid=26395
View this thread: http://www.excelforum.com/showthread...hreadid=396749

Hi,

You need a couple of extra columns to calculate the percentages within
the Requirements and Design bars.
Enter this formula in E2: =($B$21/100)*D2
copy it down to E7
Enter this formula in F8: =($B$22/100)*D8
copy it down to F18

Select cells B2:B18,E2:F18 and plot as stacked column plotting by rows.
You can use the source data dialog to add the category labels from E1:F1

Cheers
Andy

iconic83 wrote:
hi there i'm having alot of trouble trying to display data within a
column.

here is a screenshot of what i am doing:

'[img=http://img363.imageshack.us/img363/6720/graph2vr.th.jpg]'
(http://img363.imageshack.us/my.php?image=graph2vr.jpg)

the x axis is phase so each column in the graph are phases. the y axis
is time - how long each phase lasts.

but within each of the phases (columns) i would like to display data,
the final data column in the spreadsheet - "% of cost in phase". so the
phase (column) is broken down into its deliverables (the 2nd data column
in spreadsheet) according to % cost in phase (final data column in
spreadsheet)

i have been searching through the newsgroup and forum.. though the data
i want to display within the column does not relate to the y axis so a
stacked graph isn't what i am after..

any help would be greatly appreciated.. thank you!
peter



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

hi andy thank you so much!


--
iconic83
------------------------------------------------------------------------
iconic83's Profile: http://www.excelforum.com/member.php...o&userid=26395
View this thread: http://www.excelforum.com/showthread...hreadid=396749