Create Charts using VBA with different X and Y values
 

Hi
I have a spreadsheet which has four columns that data is entered into. Once
these four columns are updated then a button is pressed which does the
following:

highlights the first column from the first value and xldown to the end and
copies the data over to another worksheet.

Next it places a 1 next to each number to calcluate the number of times each
number in column A (copied from previous page) is repeated. All repeated
numbers are deleted so we are left with the number once in column A and in
column B it shows the count of column A prior to deleting for each number.

Next it copies column A & B back to the original sheet but inserts the
numbers so everything moves down.

From here it needs to create a chart from the numbers placed back to
original sheet by using column B as the Y value and column A as the X value.

Does anyone know the coding to use that will be able to complete the above
chart, keeping in mind that the chart and all the numbers will be deleted
from the original sheet to allow new data to be entered next time which means
we create a new chart again.

I hope this makes sense.

Thanks
Noemi