Graphs

[Carlo]

Is there a way to create range names for each row in a table and by
using a drop down list with these names in the list that are then used
as the series range in a graph eg

Row1 named RowA = 100 200 300 400
Row2 named RowB = 250 350 100 400
Row3 named RowC = 10 4 9 30 5
Row4 named RowD = 1000 40 500 40

Then as the graph range based on a drop down list one selects RowB and
250,350,100,400 is used in the graph. If one selects RowD then the
graph changes.

Thanks
Carlob1

 

[Kassie]

Yes you can.

Highlight each row of data, e.g. A11, click on <Insert>,<Name>,<Define> ,
type the name as Row1 and click on OK. repeat for the other rows as Row2,
Row3, Row4. Now create a Graph using one of the ranges, say Row1. If you
want to change to another row, right click on the chart area, click on Source
data, and enter the range as Row2.