Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Displaying the mean in a bar chart
Hi all,
I have a stacked bar chart showing test score distributions. I would like to be able to plot the mean score on the bar. A simple dot or square would do. Anyone know how to do this? thanks! nathan |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Displaying the mean in a bar chart
Couldn't you just add a formula of the MEDIAN of each group, add that series
to the chart, then change the chart type of that series to a line. You can then set the line colour to none, and change the style to a diamond say. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "nathanhutto" wrote in message ... Hi all, I have a stacked bar chart showing test score distributions. I would like to be able to plot the mean score on the bar. A simple dot or square would do. Anyone know how to do this? thanks! nathan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Displaying cell data in a chart | Charts and Charting in Excel | |||
Displaying Ratios in Chart scales | Excel Discussion (Misc queries) | |||
Displaying Zero Values in a Chart | Excel Discussion (Misc queries) | |||
Pie chart not displaying % in spreadsheet | Charts and Charting in Excel | |||
Problem in displaying the chart | Charts and Charting in Excel |