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].
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].