Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart updates using cell reference
I have a multiple charts that plot data in A1:Z20. Column A is always the
x-axis. Columns B-Z represent different charts. Sometimes I want to see all 20 rows of data, but sometimes I want to choose only a few rows (to zoom in) and plot only a few rows...say 8-14. I'd like to be able to put 8 in cell A22 and 14 in cell A23 and have all charts reference those entries and update to show only data in cells 8-14. Is it possible? thx - jwhprinter |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart updates using cell reference
Dynamic charts:
http://peltiertech.com/Excel/Charts/DynamicCharts.html Your offset formula for X ("myXValues") would be =INDIRECT("Sheet1!A"&Sheet1!$A$23&":A"&Sheet1!$A$2 4) and for the various Ys would be =OFFSET(myXValues,0,1) where you use 1 for column B, 2 for column C, etc. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "jwhprinter" wrote in message ... I have a multiple charts that plot data in A1:Z20. Column A is always the x-axis. Columns B-Z represent different charts. Sometimes I want to see all 20 rows of data, but sometimes I want to choose only a few rows (to zoom in) and plot only a few rows...say 8-14. I'd like to be able to put 8 in cell A22 and 14 in cell A23 and have all charts reference those entries and update to show only data in cells 8-14. Is it possible? thx - jwhprinter |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart updates using cell reference
I took a while for me to wrestle with it but I finally got it to work as
desired. Jon...you are the guru! Thanks! "Jon Peltier" wrote: Dynamic charts: http://peltiertech.com/Excel/Charts/DynamicCharts.html Your offset formula for X ("myXValues") would be =INDIRECT("Sheet1!A"&Sheet1!$A$23&":A"&Sheet1!$A$2 4) and for the various Ys would be =OFFSET(myXValues,0,1) where you use 1 for column B, 2 for column C, etc. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "jwhprinter" wrote in message ... I have a multiple charts that plot data in A1:Z20. Column A is always the x-axis. Columns B-Z represent different charts. Sometimes I want to see all 20 rows of data, but sometimes I want to choose only a few rows (to zoom in) and plot only a few rows...say 8-14. I'd like to be able to put 8 in cell A22 and 14 in cell A23 and have all charts reference those entries and update to show only data in cells 8-14. Is it possible? thx - jwhprinter |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to create a variable column in cell reference | Excel Worksheet Functions | |||
Cell Reference Math | Excel Worksheet Functions | |||
Display cell value on a chart. | Charts and Charting in Excel | |||
name of another worksheet in cell for reference | Excel Worksheet Functions | |||
cell reference show cell name (ie. D45) and not cell value | Excel Worksheet Functions |