Graphs
 

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

Yes you can.

Highlight each row of data, e.g. A1:D1, 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.


"Carlo" wrote:

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

Assuming you have a heading row at the top of your data:

Create a chart from all the data
Select a cell in the source data table
Choose DataFilterAutoFilter
From the dropdown list in heading cell for the Row Name column, select
one of the Row names, e.g. RowC
The chart will display the data for that row only.

Carlo wrote:
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


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html