Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional format based on data from another column | Excel Discussion (Misc queries) | |||
How do I strip out some parts of a column of text data? | Excel Discussion (Misc queries) | |||
2 Column Data lookup | Excel Discussion (Misc queries) | |||
Sort pages? | Excel Discussion (Misc queries) | |||
Can you average data in 1 column based on a range of values in another? | Excel Worksheet Functions |