Interactive Charting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I often use an interactive charting technique (using the INDEX function and a
combo box)to plot one set of data at a time from a list containing multiple
sets of data.

I now want to separate the data into two groups (A and B), one group (A) to
be charted using the above technique. I would like the data selection in
Chart A to trigger the charting of a corresponding/correlated set of data in
Chart B. What would be the easiest way to accomplish that?

Thanks for your help
 
Use the OFFSET function. Suppose your A data are in A2:A{whatever} and
the B data are in B2:B{whatever}. Suppose the named formula you use
for A is called AData. Then, create a new named formula BData that is
=OFFSET(AData,,1). Plot BData just as you plotted AData.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
I didn't do a good job of explaining my objective. Suppose I choose (through
a combo box) to plot data on Row 3 of "AData." What I want to accomplish is
for that specific choice to plot a specific row from "BData" on a separate
chart, say, for example Row 1. The goal is to chart data on separate charts
and in preselected pairs, having made the judgment that there is some form of
correlation between specific rows of data in "AData" and "BData."
 
Nothing changes in my suggestion except that to choose the row below
the one that represents AData use BRowData =OFFSET(ARowData,1,0). If
the BRowData are not in the next row just adjust the 1 appropriately.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
I think I got it! Thanks for your help.

Tushar Mehta said:
Nothing changes in my suggestion except that to choose the row below
the one that represents AData use BRowData =OFFSET(ARowData,1,0). If
the BRowData are not in the next row just adjust the 1 appropriately.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
Click to expand...
 
Back
Top