scatter chart

I have different values for both X-axis and Y-axis. Eg: X - axis : 34, 45, 60, 20 Y - axis : 4, 10, 80, 30 If I were to change the 'range', excel will produce two graphs. How could I edit my code so that the x and y axis will change according to the values? 'Create Graph For Coil2...

I'm trying to make a macro that will change the data labels on a scatter chart to the title of each point. Ej: In this case I would like the data labels to show the movie title. The code I used comes from this website, but my scatter chart has two series of data. I would like to use dynamic...

Hi Do any Body have Idea "How to Show Shift Q1 V/s Q2 Data in Scatter chart" i have seen this on SECTION ==> Attack and defence deconstructed: League 2 http://experimental361.wordpress.com/ If any one Know please help me ..!! it will really help in my Board presentation for Client

As I add more data to my scatter chart, I'd like it to just show the most recent 10 data points. I have date on the x-axis and I would like the chart to only show data for the 10 most recent days.

Hi, Wonder if someone can help with code for the following: Using Excel 2007, I want to plot 2 points on a scatter chart (x,y for BEFORE and x,y for AFTER). Then to join the points with a line (so far OK for a standard scatter chart), however the line needs to be an arrow with the arrowhead...