Hi!
I am trying to graph a dynamic range using VBA, but don't know how to get all of the data I need on to one chart.
I came very close, please see the attached sheet. I've gotten thus far thanks to John Peltier's blog.
The data on the sheet looks like this:
.......................Apr2 Apr 14 Apr 21
Physical percentage 90 92 93
Economic percentage 91 93 94
I can get the numbers onto the graph, but I cant get the dates to be displayed on the x-axis of the graph through VBA.
If I take the boxes around the data and drag them over the dates, they appear on the graph.
What can I do to make the dates appear on the x-axis of the chart?
Its almost done. Thank you for the help!
Bookmarks