View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
matthias matthias is offline
external usenet poster
 
Posts: 33
Default macro graph highlighting some numbers

Hello guys,

I have the following issue. On a sheet I have a graph that is
generated without a macro, so the graph already exists. I need a macro
that highlights on the x-axe a value that meets a certain criteria
(let's say equal to cell a5) and that creates a dropline from the x-axe
to the graphvalue.

If it is easier to generate the graph with the same macro let us say
that the data for x runs from a1-a10 and for y from b1-b10

thanks