Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automate Excel to powerpoint - Graphs along with Datasheet (not workbook) | Charts and Charting in Excel | |||
HELP- Copy a Data Series to Other Graphs? | Excel Discussion (Misc queries) | |||
2 graphs on 1 single chart cheet | Charts and Charting in Excel | |||
Line Graphs and Bar Graphs | Excel Discussion (Misc queries) | |||
Graphs and sheet referencing? | Excel Worksheet Functions |