A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Charts and Charting in Excel
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Cannot Add Error Bars for individual data points!



 
 
Thread Tools Display Modes
  #1  
Old August 28th 09, 10:56 PM posted to microsoft.public.excel.charting
Smirkus
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!
Ads
  #2  
Old August 29th 09, 04:52 AM posted to microsoft.public.excel.charting
Jon Peltier[_2_]
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!

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

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 11:29 PM.


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