Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 7th 09, 04:02 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: May 2009
Posts: 1
Default No tab for error bars in Excel 2007

I have a wierd problem. My company has pushed MS Office 2007 onto my
computer set to compatibility mode. When i do a scatter plot, I
follow the instructions to put Y axis error bars into the data set.
When i get to the "Format Data Series" popup, there is nothing about
error bars. How could this happen? I also tried a line graph and had
the same problem. I am running version 12.0.6214.1000 SP1 MSO
(12.0.6213.1000).

  #2   Report Post  
Old May 7th 09, 05:33 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 6,582
Default No tab for error bars in Excel 2007

This happened because of faulty interface design decisions. Apparently
nobody at Microsoft had any experience making real charts, so the features
that are needed for these charts are hidden, and even when you can find
them, they are poorly implemented.

I discuss Excel 2007 error bars in my blog at
http://peltiertech.com/WordPress/err...in-excel-2007/

Even better than discussing Excel 2007 error bars, I've built a small
utility you can use to make it easier to apply error bars in Excel 2007 and
in earlier versions.

- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
Advanced Excel Conference - June 17-18 2009 - Charting and Programming
http://peltiertech.com/Training/2009...00906ACNJ.html
_______


"Ron" wrote in message
...
I have a wierd problem. My company has pushed MS Office 2007 onto my
computer set to compatibility mode. When i do a scatter plot, I
follow the instructions to put Y axis error bars into the data set.
When i get to the "Format Data Series" popup, there is nothing about
error bars. How could this happen? I also tried a line graph and had
the same problem. I am running version 12.0.6214.1000 SP1 MSO
(12.0.6213.1000).





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
Customise error bars on individual bars in a bar chart 2007 Millie Charts and Charting in Excel 2 April 25th 09 04:16 AM
error bars on bar chart in Excel 2007 Millie Charts and Charting in Excel 1 April 23rd 09 02:14 PM
error bars in VBA excel 2007 macro Roland Charts and Charting in Excel 1 April 22nd 09 12:16 PM
excel 2007 error bars, why so complicated... mwildt Charts and Charting in Excel 4 May 7th 08 05:23 AM
cUSTOM error Bars in Excel 2007 RM2007 Excel Discussion (Misc queries) 0 June 20th 07 09:17 AM


All times are GMT +1. The time now is 12:32 AM.

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