Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Tabbing through rows
Can I create a chart that delineates any row I choose without creating a new
chart each time? The data I want to chart resides in columns B through BD and rows 22 through 1000. I'd like to use one chart that changes rows easily without having to recreate the chart for each row of data. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Tabbing through rows
Hi Nick,
Go to http://www.edferrero.com/charting.aspx and download 'Chart Selector' Ed Ferrero Microsoft Excel MVP http://www.edferrero.com Can I create a chart that delineates any row I choose without creating a new chart each time? The data I want to chart resides in columns B through BD and rows 22 through 1000. I'd like to use one chart that changes rows easily without having to recreate the chart for each row of data. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Tabbing through rows
For a tutorial on how to create a dynamic chart see
Dynamic Charts http://www.tushar-mehta.com/excel/ne...rts/index.html particularly the later examples. Of course, you will have to adapt the ideas to plot data in a row rather than in a column. I thought I had posted code that adjusted a chart based on the currently selected cell. But, I cannot find it through a search of the google archives of the XL newsgroups. Maybe, you will have better luck searching for code I posted. ;-) -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... Can I create a chart that delineates any row I choose without creating a new chart each time? The data I want to chart resides in columns B through BD and rows 22 through 1000. I'd like to use one chart that changes rows easily without having to recreate the chart for each row of data. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert rows based on specific value | Excel Worksheet Functions | |||
formula to use when number of rows changes dynamically | Excel Worksheet Functions | |||
REALLY miussing rows in Excel2000 | Excel Discussion (Misc queries) | |||
Hiding Rows if the linked rows are blank | Excel Discussion (Misc queries) | |||
Adding Rows to Master Sheet | New Users to Excel |