View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Christine Christine is offline
external usenet poster
 
Posts: 147
Default XY scatter, select item in list to flag point

I have created an XY scatter graph and included code to show a data label for
each point in a text box. I have included a drop down box to list all
possible data labels. I want to be able to select one item from the list,
and for the relevant point to then change colour.
I know I could do this using multiple series and using the drop down to
specify the second series, but this interferes with the first macro.
Any ideas?