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

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

Watch MrExcel Video

Forum statistics

Threads
1,109,053
Messages
5,526,502
Members
409,704
Latest member
saialkesh

This Week's Hot Topics

Top