ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Dynamic charting (https://www.excelbanter.com/excel-programming/306012-dynamic-charting.html)

PicaJ

Dynamic charting
 
I am creating a list of data in two columns. 1's (in the
first column) and 0's in the second column. This list is
increasing and decreasing while I run a plug in for
excel. I would like to create a bar chart that
dynamically moves along with these changes, so that as
the range increases so does the chart. Anyone got any
suggestions??????

The end product would look like clock form like this


_________
|_____________ then the range would
change and it would look like this:

______________
|____________

and so on. I imagine I can do it with a line graph but
how can I make excell change as the range
increase/decreases?

Please Help?

Frank Kabel

Dynamic charting
 
Hi
not quite sure but have a look at:
http://www.tushar-mehta.com/excel/so...art/index.html
http://peltiertech.com/Excel/Charts/Dynamics.html
http://www.tushar-mehta.com/excel/ne...rts/index.html

--
Regards
Frank Kabel
Frankfurt, Germany


PicaJ wrote:
I am creating a list of data in two columns. 1's (in the
first column) and 0's in the second column. This list is
increasing and decreasing while I run a plug in for
excel. I would like to create a bar chart that
dynamically moves along with these changes, so that as
the range increases so does the chart. Anyone got any
suggestions??????

The end product would look like clock form like this


_________
|_____________ then the range would
change and it would look like this:

______________
|____________

and so on. I imagine I can do it with a line graph but
how can I make excell change as the range
increase/decreases?

Please Help?



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

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