 |
 |
 |
 |
 |
|
|
||||||||||||
|
#1
10-06-2005, 07:05 PM
|
|||
|
|||
|
Column chart with additional "average" column
I created a vertical column chart with 10 columns of varying heights of data.
On my spreadsheet I have a cell containing the average of the data. I need to add an additional vertical column showing this average and make it stand out from the other columns somehow (ex: color and/or height of column.) Is there a way to do this? 
|
|
#2
10-07-2005, 07:05 PM
|
|||
|
|||
|
Re: Column chart with additional "average" column
Hi,
Maybe you could have the average column as the 11th column. Extend the existing data series but don't give it a value. Create another series with data for only the 11th item. You can then format the second series so make the average stand out. Or maybe you would be better off with a average line? http://www.andypope.info/charts/averageline.htm Cheers Andy Bill_S wrote: > I created a vertical column chart with 10 columns of varying heights of data. > On my spreadsheet I have a cell containing the average of the data. I need > to add an additional vertical column showing this average and make it stand > out from the other columns somehow (ex: color and/or height of column.) Is > there a way to do this? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info
|
 |
| Bookmarks |
New topics in Excel Charting
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
