| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Creating a Macro which allows me to change the data series of a ch
Scenario : I have a large data table, possibly 100 cols wide and 100 rows
deep. I have created a graph built from one column worth of data. Can I create a macro which when used will move the source of the data to the nextcolumn, with this being carried out repeatedly. I only want to display one col at a time in the graph. I would like to have two buttons - one for moving to the next column and one to move back to the previous column. Is this possible ? -- Thanks Cath |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Creating a Macro which allows me to change the data series of a ch
You do not need a macro
Suppose your data is in A1:ZZ100 Insert a new row 1 and a new column B In A1 enter the text Column, in B1 enter the column to be plotted (say V) In B2 enter =INDIRECT($B$2$ROW()) and copy down the column by double clicking the fill handle Now use columns A and B to make chart Change enter in B1 to get different data. If you would rather use numbers in B1, say 3 for the data in D, then modify the above to =INDIRECT(CHAR($B$1+65)&ROW()) best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Cath" wrote in message ... Scenario : I have a large data table, possibly 100 cols wide and 100 rows deep. I have created a graph built from one column worth of data. Can I create a macro which when used will move the source of the data to the nextcolumn, with this being carried out repeatedly. I only want to display one col at a time in the graph. I would like to have two buttons - one for moving to the next column and one to move back to the previous column. Is this possible ? -- Thanks Cath |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Creating a Macro which allows me to change the data series of a ch
Hi,
No need for a macro. You could use formula, such as INDEX, to display values of chosen column. Then create a chart on this fixed set of data. You could use a Spinner control to determine which of the 100 columns you what displayed. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Cath" wrote in message ... Scenario : I have a large data table, possibly 100 cols wide and 100 rows deep. I have created a graph built from one column worth of data. Can I create a macro which when used will move the source of the data to the nextcolumn, with this being carried out repeatedly. I only want to display one col at a time in the graph. I would like to have two buttons - one for moving to the next column and one to move back to the previous column. Is this possible ? -- Thanks Cath |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Creating a Macro which allows me to change the data series of a ch
Much more creative than my answer, Andy!
But I do have a bad case of 'flu best wishes -- Bernard "Andy Pope" wrote in message ... Hi, No need for a macro. You could use formula, such as INDEX, to display values of chosen column. Then create a chart on this fixed set of data. You could use a Spinner control to determine which of the 100 columns you what displayed. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Cath" wrote in message ... Scenario : I have a large data table, possibly 100 cols wide and 100 rows deep. I have created a graph built from one column worth of data. Can I create a macro which when used will move the source of the data to the nextcolumn, with this being carried out repeatedly. I only want to display one col at a time in the graph. I would like to have two buttons - one for moving to the next column and one to move back to the previous column. Is this possible ? -- Thanks Cath |
|
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Creating a Macro which allows me to change the data series of
Thanks works very well!
-- Thanks Cath "Bernard Liengme" wrote: You do not need a macro Suppose your data is in A1:ZZ100 Insert a new row 1 and a new column B In A1 enter the text Column, in B1 enter the column to be plotted (say V) In B2 enter =INDIRECT($B$2$ROW()) and copy down the column by double clicking the fill handle Now use columns A and B to make chart Change enter in B1 to get different data. If you would rather use numbers in B1, say 3 for the data in D, then modify the above to =INDIRECT(CHAR($B$1+65)&ROW()) best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Cath" wrote in message ... Scenario : I have a large data table, possibly 100 cols wide and 100 rows deep. I have created a graph built from one column worth of data. Can I create a macro which when used will move the source of the data to the nextcolumn, with this being carried out repeatedly. I only want to display one col at a time in the graph. I would like to have two buttons - one for moving to the next column and one to move back to the previous column. Is this possible ? -- Thanks Cath |
|
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Creating a Macro which allows me to change the data series of a ch
Thanks' Bernard, but we were both 'singing' from the same sheet on this one
:) Hope your bout of flu is a short one. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Bernard Liengme" wrote in message ... Much more creative than my answer, Andy! But I do have a bad case of 'flu best wishes -- Bernard "Andy Pope" wrote in message ... Hi, No need for a macro. You could use formula, such as INDEX, to display values of chosen column. Then create a chart on this fixed set of data. You could use a Spinner control to determine which of the 100 columns you what displayed. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Cath" wrote in message ... Scenario : I have a large data table, possibly 100 cols wide and 100 rows deep. I have created a graph built from one column worth of data. Can I create a macro which when used will move the source of the data to the nextcolumn, with this being carried out repeatedly. I only want to display one col at a time in the graph. I would like to have two buttons - one for moving to the next column and one to move back to the previous column. Is this possible ? -- Thanks Cath |
|
#7
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Creating a Macro which allows me to change the data series of a ch
Many Thanks
-- Thanks Cath "Cath" wrote: Scenario : I have a large data table, possibly 100 cols wide and 100 rows deep. I have created a graph built from one column worth of data. Can I create a macro which when used will move the source of the data to the nextcolumn, with this being carried out repeatedly. I only want to display one col at a time in the graph. I would like to have two buttons - one for moving to the next column and one to move back to the previous column. Is this possible ? -- Thanks Cath |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I change the shape of a data series | Charts and Charting in Excel | |||
| Data Series rate of change (trend) | Excel Worksheet Functions | |||
| Creating a data series using another worksheet? | Excel Discussion (Misc queries) | |||
| ?-Change data series range as data is entered? | Charts and Charting in Excel | |||
| Creating a series of data | Excel Worksheet Functions | |||
Linear Mode
