View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Francois
 
Posts: n/a
Default Find the value of a point with VBA

Hi all,

Pardon my english ! I'm french.

I need to find the values of points of a serie (in charts of course)
with VBA. I can't refer to the value of the source cells because of the
very bad organization of the source sheets.

The only way I found is to add datalabels, pick the datalabels values,
convert them to numeric values.

Is there a shorter method to do that ? (XL2K)

I did not find the answer on the french speaking excel newsgroup though
it's very active and frendly.

Thanks

--
François L