#1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default excel 2000

At school we use excel 2000, i am trying to make a scatter graph with
error bars. Every time i try to use the error bars it makes every
point have the same error bar, when i would like them to be different.
Can anyone help?
  #2   Report Post  
Posted to microsoft.public.excel.charting
Xt Xt is offline
external usenet poster
 
Posts: 49
Default excel 2000

On Jul 5, 9:50*pm, Laura Williams wrote:
At school we use excel 2000, i am trying to make a scatter graph with
error bars. Every time i try to use the error bars it makes every
point have the same error bar, when i would like them to be different.
Can anyone help?


I'm not sure about Excel 2000, but the following instructions which I
have cut out of some student notes work for 1997 and 2003. The
students have drawn a column chart of the results of a political poll
and have the margin of error MoE alongside the data.
---------------------
Chart with error bars
highlight the party names and the party percentage
draw a Column chart
right click on one of the bars
Format Data Series
Y Error Bars
Custom + highlight the MoE range
- highlight the MoE range
---------------
It might help.

xt


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
Open 2000 file attachments in Excel 2000 Judy[_2_] Excel Discussion (Misc queries) 2 September 20th 07 10:20 PM
I cannot edit cell format in Excel 2000 (Part of office 2000)! Brett Excel Discussion (Misc queries) 1 April 12th 06 05:58 PM
Using Excel 2000 as Data source for Word 2000 document Malcolm Agingwell Excel Discussion (Misc queries) 2 June 21st 05 09:28 AM
Hyperlink in Excel 2000 can't open bookmarked Word 2000 file DCheslock Excel Discussion (Misc queries) 1 May 5th 05 10:46 PM
Excel Programs developed in Office 2000 on Windows 2000 Trooper Excel Discussion (Misc queries) 4 March 13th 05 12:09 AM


All times are GMT +1. The time now is 01:42 AM.

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

About Us

"It's about Microsoft Excel"