View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
[email protected] dcxtxtxtxt@gmail.com is offline
external usenet poster
 
Posts: 6
Default Average bar charts with individual data points

On Friday, April 26, 2013 7:15:25 AM UTC+12, Nimbox wrote:
Hi,



I am trying to produce a bar chart displaying averages for 4 variables,

but also plotting the individual data points horizontally on each bar.



This is the most similar example I could find:

http://jcb.rupress.org/content/177/1/7/F1.expansion



I am awful with excel; obviously I have managed to make the simple bar

chart with the average values, but I am having difficulty adding the

individual data points to each bar. Apparently this involves combining

scatter points.



Is anyone able to explain simply how I do this?


(Excel 2007) Here is a way which might do what you want but it is a little involved. Make a table with categories and the data and averages, something like this -

A B C D E
15 50 26 31 36
34 13 50 37 24
37 39 35 38 21
49 47 23 17 40
33.75 37.25 33.5 30.75 30.25

Highlight the whole lot and Insert - Line chart - pick the first one with dots. Delete the legend. You now have five lines of different colours and markers.

Locate the line which is the averages, right click on it and Change Series Chart Type to Column. You now have one bar for the averages and four lines..

Now right click on one of the line charts - Format the Data Series. Make the Line Colour = No line. Make the Marker Options = Built in - round size 3 or whatever you like the look of. Marker Fill = Solid Fill black. The co;oured line should now be little black dots.

Repeat with the other three lines.

Cheers

dc