Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Highlight a row
Here is what I am trying to accomplish.
I want one controlling cell in my spreadsheet where I manually write a number from 1 to 10. The spreadsheet has 10 rows with data for 10 variables for different dates (different columns in the table). When I write say number 6 in the controlling cell, The simple XY chart in my spreadsheet should take values from row number 6 and update the plot. The data in row 6 is obviously the Y variable. The X variable is the date variables which are mentioned in the same common row for all the 10 variables. Basically I should be able to step thru the 10 different data sets without having to plot 10 different plots. Is there any way of doing this in Excel? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Highlight changes | Excel Discussion (Misc queries) | |||
how to highlight more related cells if cell highlight | Excel Discussion (Misc queries) | |||
Highlight active cell and de-highlight previous cell | Excel Programming | |||
Highlight cells with ctrl-click but only un-highlight one cell | Excel Discussion (Misc queries) | |||
how do i highlight every odd row | Excel Discussion (Misc queries) |