Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Column Chart
Dear all,
I have a 'Stacked Column Chart' that indicates the total cost of numerous buildings and the breakdown of buildings' costs. X-axis: name of each building Y-axis: cost I wish to add two lines accross the graph. One for the mean total cost and another for the median total cost. Assuming it is possible, how would I go about doing this? Thanking-you in advance, Neil |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Column Chart
Hi,
Create two new series one using =AVERAGE(costs), the other using =MEDIAN(costs). This means you have both repeated many times. Hightlight these two sets of data and copy them. Select the chart and paste them. Select the series for the new columns on the chart and choose Chart, Chart Type, Line. Repeat for the other new series. Format as desired - for example set markers to None. -- Thanks, Shane Devenshire "Neil Pearce" wrote: Dear all, I have a 'Stacked Column Chart' that indicates the total cost of numerous buildings and the breakdown of buildings' costs. X-axis: name of each building Y-axis: cost I wish to add two lines accross the graph. One for the mean total cost and another for the median total cost. Assuming it is possible, how would I go about doing this? Thanking-you in advance, Neil |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Column Chart
Additionally found walk through at...
www.andypope.info/charts/averageline.htm Many thanks Shane. "Neil Pearce" wrote: Dear all, I have a 'Stacked Column Chart' that indicates the total cost of numerous buildings and the breakdown of buildings' costs. X-axis: name of each building Y-axis: cost I wish to add two lines accross the graph. One for the mean total cost and another for the median total cost. Assuming it is possible, how would I go about doing this? Thanking-you in advance, Neil |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Column Chart - Adding text in the column in Excel 2007 | Charts and Charting in Excel | |||
Needed: Chart that combines clustered column and stacked column types | Charts and Charting in Excel | |||
How to combine stacked column with a cluster column chart? | Charts and Charting in Excel | |||
Stacked Column Chart / Normal Column Chart | Charts and Charting in Excel | |||
How can I add a line chart in a stacked column chart style? | Excel Discussion (Misc queries) |