Forum Discussion

efischer635's avatar
efischer635
Copper Contributor
Jul 05, 2023

Shortcut to change the column that is plotted in a chart

I use Excel to plot a lot of charts, but so far I have not been able to figure out a shortcut to changing the column that is plotted.    For example, I have a chart that is plotting $D$87:$D$95 vs ...
Charting
excel
SnowMan55's avatar
SnowMan55
Bronze Contributor
Jul 09, 2023

efischer635 

See the attached workbook. Particularly if you work with a consistent number of rows of data, it may be useful to use the INDIRECT function and the OFFSET function as I have done in four formulas – in K6:L7 – to change the content of a fixed range to be charted. (The INDIRECT function can also be used to refer to cells on other worksheets, e.g., if you want the data and the chart on separate worksheets. The OFFSET function in this case spills its selected content to multiple rows.) Modify the values in cells L2 and L3 to see the results.


This would work best if you only need to view/print the chart with each change. If you need to copy the results to a new worksheet, then within that new sheet Copy + Paste Values for the K6:L15 range to itself.

 

Resources