No tab for error bars in Excel 2007

R

Ron

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).
 
J

Jon Peltier

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/error-bars-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-06-ACNJ/AdvExcelConf200906ACNJ.html
_______
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Error bars not displaying properly 0
removing horizontal error bars in excel 2007 chart 4
Cannot Add Error Bars for individual data points! 1
error bars 1
error bars on bar chart in Excel 2007 1
Trendline for chart with error bars 2
switching the axes, categories to values and vice versa 0
error bars in VBA excel 2007 macro 1

Top