Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Data Point labeling
I have created a simple line chart. I want the data points to be labeled
with information from a column that is not included in the data or series range. Can I do this easily? N. VB programming please Also, how can I have one data point on this line chart show up as either a different color or different shape when the value is less than a std number? (I am trying to highlight an out of spec condition). thanks! |
#2
|
|||
|
|||
Hi,
Here is a free addin you code use to label the points with text in cells http://www.appspro.com/Utilities/ChartLabeler.htm If "N. VB programming please" means no addin then see the page on how to do it manually. http://www.andypope.info/tips/tip001.htm To create a conditional chart have a look here. http://peltiertech.com/Excel/Charts/...nalChart1.html Cheers Andy Russell-stanely wrote: I have created a simple line chart. I want the data points to be labeled with information from a column that is not included in the data or series range. Can I do this easily? N. VB programming please Also, how can I have one data point on this line chart show up as either a different color or different shape when the value is less than a std number? (I am trying to highlight an out of spec condition). thanks! -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I import formmail data to a custom excel template? | Excel Worksheet Functions | |||
Import Data Keeps asking for Password | Excel Discussion (Misc queries) | |||
Removing blank rows in a worksheet | Excel Worksheet Functions | |||
scatter plot & label for a data point | Charts and Charting in Excel | |||
Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) |