Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default Cannot Add Error Bars for individual data points!

I work in a research lab, and need to make a simple column chart. However,
each column is an average value so error bars are needed. Not only that, but
I have subsets of data-the same readings taken at different times.

Thus I have Null and Dose readings for 0 hours and 24 hours. I have nicely
gotten the 0 hour and 24 hour sets to become set apart in the graph display
with the proper Null and Dose values next to each other. The 0 and 24 hours
are written under the pairs of bars. However, I need to add error bars to
each bar individually, but Excel will only let me add to "series" of data,
which in this graph are the "null" and "dose" series.

So I tried to make each data point into its own series so I could add the
correct error bars, however, I then lost/cannot make any groupings in the
graph to denote "0 hour" and "24 hour" groups, and "null" and "dose" groups.

PLEASE HELP!
  #2   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up Answer: Cannot Add Error Bars for individual data points!

It sounds like you are trying to add error bars to individual data points in your Excel column chart, but are having trouble doing so because Excel only allows you to add error bars to a series of data. However, you also need to group your data by subsets (e.g. null vs. dose, 0 hours vs. 24 hours).
  1. Select your chart and click on the "Chart Design" tab in the ribbon.
  2. Click on "Select Data" in the "Data" group.
  3. In the "Select Data Source" dialog box, click on the "Switch Row/Column" button if your data is organized by rows instead of columns.
  4. Click on the "Add" button to add a new series of data.
  5. In the "Edit Series" dialog box, enter a name for your new series (e.g. "Null 0 Hours").
  6. In the "Series X values" field, select the range of cells that contain the X values for this series (e.g. the range of cells that contain the null values for 0 hours).
  7. In the "Series Y values" field, select the range of cells that contain the Y values for this series (e.g. the range of cells that contain the average values for the null values at 0 hours).
  8. Click "OK" to close the dialog box and add the new series to your chart.
  9. Repeat steps 4-8 for each subset of data that you want to group together (e.g. "Null 24 Hours", "Dose 0 Hours", "Dose 24 Hours").
  10. Once you have added all of your series, click on one of the bars in your chart to select the entire series.
  11. Click on the "Chart Design" tab in the ribbon and click on "Add Chart Element" in the "Chart Layouts" group.
  12. Select "Error Bars" and then "More Error Bar Options".
  13. In the "Format Error Bars" pane that appears on the right side of the screen, select "Custom" under "Error Amount".
  14. Click on the "Specify Value" button and then select the range of cells that contain the error values for the selected series (e.g. the range of cells that contain the standard deviation values for the null values at 0 hours).
  15. Click "OK" to close the dialog box and add the error bars to your chart.
  16. Repeat steps 10-15 for each series in your chart.

By adding each subset of data as its own series, you can add error bars to individual data points while still grouping your data by subsets.
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 461
Default Cannot Add Error Bars for individual data points!

You don't need to define each point as its own series. Instead, plot the
data as the 0 hour and 24 hour series. In the next couple of cells,
enter the error bar values for each point in the same row as the plotted
average for each point. Format each series to use the appropriate column
for its custom error bar values.

Here is further information:

Error Bars in Excel Charts
http://peltiertech.com/Excel/ChartsHowTo/ErrorBars.html

Error Bars in Excel 2007
http://peltiertech.com/WordPress/err...in-excel-2007/

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



Smirkus wrote:
I work in a research lab, and need to make a simple column chart. However,
each column is an average value so error bars are needed. Not only that, but
I have subsets of data-the same readings taken at different times.

Thus I have Null and Dose readings for 0 hours and 24 hours. I have nicely
gotten the 0 hour and 24 hour sets to become set apart in the graph display
with the proper Null and Dose values next to each other. The 0 and 24 hours
are written under the pairs of bars. However, I need to add error bars to
each bar individually, but Excel will only let me add to "series" of data,
which in this graph are the "null" and "dose" series.

So I tried to make each data point into its own series so I could add the
correct error bars, however, I then lost/cannot make any groupings in the
graph to denote "0 hour" and "24 hour" groups, and "null" and "dose" groups.

PLEASE HELP!

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
Coloring individual points/bars PBezucha Charts and Charting in Excel 0 August 6th 09 06:44 AM
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
excel should let you vary error bars for individual points CRC Charts and Charting in Excel 4 July 5th 06 11:52 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 04:17 PM.

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

About Us

"It's about Microsoft Excel"