Excel Graph from two cell

[vasc]

Hi my friends...
Excel Graph.xlsx use classic method to show graphic.
With some formula i find first and last cell with data in range E:E

How learn excel to use h3 and h4 for show graphic like classic method?

any help willl be appercied...

[Kaper]

You may use so called dynamic graph (seems you have already tried - as there are some defined names in your workbook. May be watch some tutorial on this (again) - you may be missing something).

Anyway, as you already have the beginning and the end of the range to be plotted on the graph yo may do it that way:

Define a name (Ctrl+F3) - for instance Range_for_graph as:

Please Login or Register  to view this content.

and then use it as a source for the graph series.

See attached

[vasc]

thanks
solved