Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old April 25th 13, 08:15 PM
Junior Member
 
First recorded activity by ExcelBanter: Apr 2013
Posts: 1
Question Average bar charts with individual data points

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?

Cheers

  #2   Report Post  
Old April 29th 13, 06:15 AM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2013
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
  #3   Report Post  
Old April 19th 14, 09:01 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2014
Posts: 1
Default Average bar charts with individual data points

This is great
thanks so much

On Sunday, April 28, 2013 10:15:30 PM UTC-7, wrote:
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




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
individual data points and group mean jaime Charts and Charting in Excel 2 July 13th 08 11:48 PM
How do I specify min/max error bars for individual data points? jvitters Charts and Charting in Excel 1 June 11th 07 04:28 PM
add individual data points to a bar chart of averages lenos Charts and Charting in Excel 2 May 31st 07 08:55 AM
Calculate and display individual error bars for individual points del Charts and Charting in Excel 2 March 31st 06 05:11 PM
Calculate and display individual error bars for individual points del Charts and Charting in Excel 1 March 31st 06 04:24 AM


All times are GMT +1. The time now is 01:07 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017