VBA For Dynamic Charts

doofusboy

Well-known Member
Joined
Oct 14, 2003
Messages
1,325
Can anyone provide some sample code I might learn from that will allow me to use VBA to create some dynamic charts?

I have a situation where BOTH the x and y axes of the graph need to be dynamic and I need to show labels in the graph for only those rows that have activity [a value in the column] and show in the legend only those columns that have headings with activity [rows with data].
 

Some videos you may like

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

Watch MrExcel Video

Forum statistics

Threads
1,114,230
Messages
5,546,641
Members
410,751
Latest member
Mike Davis 1977
Top