A Microsoft Office (Excel, Word) forum. OfficeFrustration

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 » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Cannot Add Error Bars for individual data points!



 
 
Thread Tools Display Modes
  #1  
Old August 28th, 2009, 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!
  #2  
Old August 29th, 2009, 04:52 AM posted to microsoft.public.excel.charting
Jon Peltier[_2_]
external usenet poster
 
Posts: 386
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 Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 03:16 PM.


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