If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Charting Results with Comments
I have a chart the shows analysis data of a chemical solution.
Sometimes we make new solutions or calibrate the analyzer. I want to be able to show these on the line graph, but don't want to make a 'text box' on the graph each time (not all my users would know how). I have a column that allows them to enter these comments...is there a way to show them? |
#2
|
|||
|
|||
Charting Results with Comments
Hi, the easy way is to copy the cells with comments and paste it to chart as
a picture with links to input comment cells. That means, u will have comments visible in chart as an embedded object, once u change comments in a given cell, it will be automatically adopted in the chart. HTH "PosseJohn" wrote: I have a chart the shows analysis data of a chemical solution. Sometimes we make new solutions or calibrate the analyzer. I want to be able to show these on the line graph, but don't want to make a 'text box' on the graph each time (not all my users would know how). I have a column that allows them to enter these comments...is there a way to show them? |
#3
|
|||
|
|||
Charting Results with Comments
Hi,
What you need is the XLChartLabeler free add-in: http://www.appspro.com/Utilities/ChartLabeler.htm -- If this helps, please click the Yes button. Cheers, Shane Devenshire "PosseJohn" wrote: I have a chart the shows analysis data of a chemical solution. Sometimes we make new solutions or calibrate the analyzer. I want to be able to show these on the line graph, but don't want to make a 'text box' on the graph each time (not all my users would know how). I have a column that allows them to enter these comments...is there a way to show them? |
#4
|
|||
|
|||
Charting Results with Comments
Hi Shane, thanks for it, I have installed and currently am playing with this
nice toy. "Shane Devenshire" wrote: Hi, What you need is the XLChartLabeler free add-in: http://www.appspro.com/Utilities/ChartLabeler.htm -- If this helps, please click the Yes button. Cheers, Shane Devenshire "PosseJohn" wrote: I have a chart the shows analysis data of a chemical solution. Sometimes we make new solutions or calibrate the analyzer. I want to be able to show these on the line graph, but don't want to make a 'text box' on the graph each time (not all my users would know how). I have a column that allows them to enter these comments...is there a way to show them? |
#5
|
|||
|
|||
Charting Results with Comments
Hi Alojz,
Glad to help. This is one of a number of such free add-in on the web, but this is the one I use, its tried and true. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Alojz" wrote: Hi Shane, thanks for it, I have installed and currently am playing with this nice toy. "Shane Devenshire" wrote: Hi, What you need is the XLChartLabeler free add-in: http://www.appspro.com/Utilities/ChartLabeler.htm -- If this helps, please click the Yes button. Cheers, Shane Devenshire "PosseJohn" wrote: I have a chart the shows analysis data of a chemical solution. Sometimes we make new solutions or calibrate the analyzer. I want to be able to show these on the line graph, but don't want to make a 'text box' on the graph each time (not all my users would know how). I have a column that allows them to enter these comments...is there a way to show them? |
Thread Tools | |
Display Modes | |
|
|