VBA (Excel) macro question

[Anubis]

is there a macro out there that will plot data with the axis reversed? or easily flip what is on each axis. Now i don't mean simply sorting the data differently or simply flipping the data around teh axis.

What i want is the Y axis to be my constant so say -100 to +100 and have all my data be graphed vertically and not horizontally.

so say i had a set of data like this

Col A    Col B
-20	50
-19	48
-18	46
-17	44
-16	42
-15	40
-14	38
-13	36
-12	34
-11	32
-10	30
-9	28
-8	26
-7	24
-6	22
-5	20
-4	18
-3	16
-2	14
-1	12
0	10
1	12
2	14
3	16
4	18
5	20
6	22
7	24
8	26
9	28
10	30
11	32
12	34
13	36
14	38
15	40
16	42
17	44
18	46
19	48
20	50

i want Col A set as the Y axis. the only way i know how to do this is to set it manually which is a major PITFA when you have 100 columns of data you want to arange this way. I want to be able to just highlight my data and hit graph and have it work or graph it as a normal scatter plot and then simply press a button to flop the axis

heres a picture to help explain

 

[Oyster]

Does this help: http://peltiertech.com/Excel/ChartsHowTo/VBAExcelXYCharts.html

Of course, you'll have to modify the code to your liking, but I think you can manage that.

 

[Anubis]

woot yes thats exactly what i mean, shouldn't be hard to make that work for what i want