Help Wanted: 2 value axises in pivot chart

[kristoffransen]

I need both the X and Y-axis of my pivot chart to be a value axis. Ho
can I change the X-as to become a value axis instead of a categor
axis? Easily or by using visual basic. I'm using the 1997 and 200
version of Excel

 

[Tom Ogilvy]

XY Scatter Plot?

 

[kristoffransen]

You can't choose Scatter plot as a pivot char

 

[Tom Ogilvy]

That is the only plot that has two value axes.