| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need help Utilizing Dynamic ranges for creating charts
Here is my situation. I have to create several charts based on data that may
or may not exist in certain forms. I can program for those variables if I wasnt using a chart...however my boss wants a chart!! My specific issue is this: I can't for the life of me, figure out how to get the values in a chart to accept anything other than the "Sheet1!R2C1,Sheet1!R2C2" etc etc. how do I get "Activechart.SeriesCollection(1).Values = " to work with dynamic ranges? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating dynamic ranges which are named. | Excel Worksheet Functions | |||
| Dynamic cell ranges in charts | Charts and Charting in Excel | |||
| Dynamic charts without Named Ranges? | Charts and Charting in Excel | |||
| a question regarding dynamic ranges and charts | Charts and Charting in Excel | |||
| Dynamic data ranges and Charts | Excel Programming | |||
Threaded Mode
