| Home |
| Search |
| Today's Posts |
|
#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 |
| 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 | |||
Threaded Mode
