| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Chart Range
Hello!
How can I make a chart range in excel changes dynamiclly when values number changes, meaning the i have my data from external source and it's not always the same, I just want to make the chart response to how many rows are there. I hope I was clear, my english is not that much! Thank you in advanced.. |
|
#2
|
|||
|
|||
|
Hi,
Have a look at Jon's examples of dynamic charts using named ranges. http://peltiertech.com/Excel/Charts/Dynamics.html Cheers Andy En. Adel wrote: Hello! How can I make a chart range in excel changes dynamiclly when values number changes, meaning the i have my data from external source and it's not always the same, I just want to make the chart response to how many rows are there. I hope I was clear, my english is not that much! Thank you in advanced.. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Charting data points and show a target range on the same chart. | Charts and Charting in Excel | |||
| how to change range for dynamic chart in excel 2000 with button? | Charts and Charting in Excel | |||
| dynamic range for excel chart | Excel Discussion (Misc queries) | |||
| named range refers to: in a chart | Excel Discussion (Misc queries) | |||
| pivot table multi line chart | Charts and Charting in Excel | |||
Linear Mode
