ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How do I make a chart take into account a varying number of rows? (https://www.excelbanter.com/charts-charting-excel/191907-how-do-i-make-chart-take-into-account-varying-number-rows.html)

leo

How do I make a chart take into account a varying number of rows?
 
I use VB to output some data to a column, however the number of rows changes
each time. how can i produce a chart that takes this into account?

Jon Peltier

How do I make a chart take into account a varying number of rows?
 
Dynamic Charts:
http://peltiertech.com/WordPress/200...ynamic-charts/
http://peltiertech.com/Excel/Charts/Dynamics.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Leo" wrote in message
...
I use VB to output some data to a column, however the number of rows
changes
each time. how can i produce a chart that takes this into account?





All times are GMT +1. The time now is 11:33 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com