| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide or show data labels depending on value?
I did a learn macro on one of my charts. I selected only one point on a
scatter plot. Below is the code that was generated when I set x and y. the showvalue parameter was set true ActiveChart.SeriesCollection(1).Points(8).Select ActiveChart.SeriesCollection(1).Points(8).ApplyDat aLabels AutoText:=True, _ LegendKey:=False, ShowSeriesName:=False, ShowCategoryName:=True, _ ShowValue:=True, ShowPercentage:=False, ShowBubbleSize:=False "L. Lancin" wrote: I have a chart where I would like to either show or hide data labels for individual points depending on the value of the points. Does anyone know of ways of doing this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I show a picture depending on what data is selected in a cell | Excel Discussion (Misc queries) | |||
| How to hide/show a textbox depending on cell value | Excel Programming | |||
| Want to show/hide cells depending on other cells results | Excel Discussion (Misc queries) | |||
| How do I hide data labels that show a zero value on histograms? | Charts and Charting in Excel | |||
| How do I hide data labels in a pie chart that have a value of 0? | Charts and Charting in Excel | |||
Threaded Mode
