I recorded the below macro, used to manipulate and graph 5 sets of data, and it does what i want with the exception of 2 things:

1. The macro is currently used to graph data from a fixed range of cells. In reality, the number of rows will vary from data set to data set, which will either cause a bunch of 0,0 coordinates to plot on the chart or not capture all of the necessary data causing my chart to be incomplete. I would like to have the macro capture only the range that contains the data.

2. The x axis title does not appear on my charts when i run the macro...

also, the keyboard shortcut doesnt seem to work, but as i can just select and run the macro it's really a non-issue

thanks for your help

Jeff


Please Login or Register  to view this content.