ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   x or y error bars? where are they? (https://www.excelbanter.com/charts-charting-excel/108846-x-y-error-bars-where-they.html)

Chantel

x or y error bars? where are they?
 
I cannot find the x or y error bar tabs in the format data series menu.

Jon Peltier

x or y error bars? where are they?
 
What's the chart type?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Chantel" wrote in message
...
I cannot find the x or y error bar tabs in the format data series menu.




Chantel

x or y error bars? where are they?
 
What do you mean by chart type? It is a bar graph

"Jon Peltier" wrote:

What's the chart type?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Chantel" wrote in message
...
I cannot find the x or y error bar tabs in the format data series menu.





Andy Pope

x or y error bars? where are they?
 
You not referring to Excel 2007 beta by any chance are you? In which
case look on the Analysis section of the Layout tab within Chart Tools
chunk.

Cheers
Andy

Chantel wrote:
What do you mean by chart type? It is a bar graph

"Jon Peltier" wrote:


What's the chart type?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Chantel" wrote in message
...

I cannot find the x or y error bar tabs in the format data series menu.





--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Chantel

x or y error bars? where are they?
 
No but thanks anyway! I found out how to do it. The error bars didn't come
up on the 3D chart type bar graphs. But i tried a different chart type and i
found the error bar option.

"Andy Pope" wrote:

You not referring to Excel 2007 beta by any chance are you? In which
case look on the Analysis section of the Layout tab within Chart Tools
chunk.

Cheers
Andy

Chantel wrote:
What do you mean by chart type? It is a bar graph

"Jon Peltier" wrote:


What's the chart type?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Chantel" wrote in message
...

I cannot find the x or y error bar tabs in the format data series menu.




--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info


Andy Pope

x or y error bars? where are they?
 
Thanks for letting us know how you resolved your problem.

Cheers
Andy

Chantel wrote:
No but thanks anyway! I found out how to do it. The error bars didn't come
up on the 3D chart type bar graphs. But i tried a different chart type and i
found the error bar option.

"Andy Pope" wrote:


You not referring to Excel 2007 beta by any chance are you? In which
case look on the Analysis section of the Layout tab within Chart Tools
chunk.

Cheers
Andy

Chantel wrote:

What do you mean by chart type? It is a bar graph

"Jon Peltier" wrote:



What's the chart type?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Chantel" wrote in message
...


I cannot find the x or y error bar tabs in the format data series menu.



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Jon Peltier

x or y error bars? where are they?
 
Yet another reason you should avoid charts with fake 3D effects. The major
reason is that they can distort data but they also do not allow the same
kind of added features that serious charts require.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Chantel" wrote in message
...
No but thanks anyway! I found out how to do it. The error bars didn't
come
up on the 3D chart type bar graphs. But i tried a different chart type and
i
found the error bar option.

"Andy Pope" wrote:

You not referring to Excel 2007 beta by any chance are you? In which
case look on the Analysis section of the Layout tab within Chart Tools
chunk.

Cheers
Andy

Chantel wrote:
What do you mean by chart type? It is a bar graph

"Jon Peltier" wrote:


What's the chart type?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Chantel" wrote in message
...

I cannot find the x or y error bar tabs in the format data series
menu.




--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info





All times are GMT +1. The time now is 05:42 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com