Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I place an average bar gray-scale in the background?
I am trying to make a bar graph that displays four data sets and compares
each to an overall average. However, rather than having the average displayed as a fifth bar I would like it displayed as a gray-scale in the background. Any ideas? |
#2
|
|||
|
|||
plot the average a fifth catagory. select it and change axis to secondary.
(you may need to change the others to secondary depending on what you want the final display to look like.) set your y axis as you want them and set the average bar to the format you want. Note you may need to add the second X axis in chart options and change the data series to just one data point depending on what you want. "Red_Ink" wrote: I am trying to make a bar graph that displays four data sets and compares each to an overall average. However, rather than having the average displayed as a fifth bar I would like it displayed as a gray-scale in the background. Any ideas? |
#3
|
|||
|
|||
The average column would have to be on the primary axis, because the secondary axis
columns will plot in front of it. Set a gap width of 0% for the average column (double click, Options tab) so it spans the width of the chart. The procedure is a bit complicated. Make the chart with the one point series, comprising the average. Add the series of the four original points. Double click this series, and on the Axis tab, select Secondary. Go to Chart Options on the Chart menu and check the secondary X axis. The four-point series is now hanging from the top of the chart: lots of times people give up here. Double click the left hand Y axis, and check the Category Crosses at Maximum Value box, on the Scale tab. Double click the right hand Y axis, and clear the Category Crosses at Maximum Value box, on the Scale tab. The four column series has transformed from stalagtites to stalagmites, and now the average column is hanging from the ceiling. Double click the top X axis, and on the Scale tab, check the Y Axis Crosses at Maximum Category box. Double click the bottom X axis, and on the Scale tab, clear the Y Axis Crosses at Maximum Category box. Go back to Chart Options on the Chart menu, and uncheck the primary Y axis box. Double click the top X axis, and on the Patterns tab, select None wherever it appears. Now double click the Average column hanging from the top. Shade this the color for greater than Average. Double click the background below this average column, and shade it the color for less than average. Phew! Finally we've finished. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ bj wrote: plot the average a fifth catagory. select it and change axis to secondary. (you may need to change the others to secondary depending on what you want the final display to look like.) set your y axis as you want them and set the average bar to the format you want. Note you may need to add the second X axis in chart options and change the data series to just one data point depending on what you want. "Red_Ink" wrote: I am trying to make a bar graph that displays four data sets and compares each to an overall average. However, rather than having the average displayed as a fifth bar I would like it displayed as a gray-scale in the background. Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error Handling #N/A with AVERAGE Function - Average of values in Row | Excel Worksheet Functions | |||
plotted Average | Charts and Charting in Excel | |||
What is this kind of average called? | Excel Worksheet Functions | |||
AVERAGE and STDEV functions with logic | Excel Worksheet Functions | |||
GradeBook | Excel Worksheet Functions |