ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Error bars (https://www.excelbanter.com/charts-charting-excel/132392-error-bars.html)

Trichotos

Error bars
 
I've recently learned how to get error bars on my charts. I was now
wondering if there is a way to have a value attached to the error bar appear
above it. Or, if there is a way in general to place values you assign above
parts of a chart, like an error bar.

Trichotos

Jon Peltier

Error bars
 
I will often add an XY series with custom data point labels, with X and Y
calculated to put the label where I want.

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


"Trichotos" wrote in message
...
I've recently learned how to get error bars on my charts. I was now
wondering if there is a way to have a value attached to the error bar
appear
above it. Or, if there is a way in general to place values you assign
above
parts of a chart, like an error bar.

Trichotos




Trichotos

Error bars
 
I hate to be annoying but how do you make a custom data point label.

trichotos


"Jon Peltier" wrote:

I will often add an XY series with custom data point labels, with X and Y
calculated to put the label where I want.

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


"Trichotos" wrote in message
...
I've recently learned how to get error bars on my charts. I was now
wondering if there is a way to have a value attached to the error bar
appear
above it. Or, if there is a way in general to place values you assign
above
parts of a chart, like an error bar.

Trichotos





Jon Peltier

Error bars
 
If it's just one label, I add labels to the series, using any of the
options, like series name. Then I select the label, and edit its text. If
it's a number of labels, I use one of these free Excel utilities:

Rob Bovey's Chart Labeler, http://appspro.com
John Walkenbach's Chart Tools, http://j-walk.com

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


"Trichotos" wrote in message
...
I hate to be annoying but how do you make a custom data point label.

trichotos


"Jon Peltier" wrote:

I will often add an XY series with custom data point labels, with X and Y
calculated to put the label where I want.

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


"Trichotos" wrote in message
...
I've recently learned how to get error bars on my charts. I was now
wondering if there is a way to have a value attached to the error bar
appear
above it. Or, if there is a way in general to place values you assign
above
parts of a chart, like an error bar.

Trichotos








All times are GMT +1. The time now is 07:57 AM.

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