Engineering charts - too much data, i can't graph, HELP!

[greg.begin]

I am trying to scatter plot measurements of angles, I have 360 degrees listed on the columns and I have 243,000 measurements, each measurement is placed depending on the degree it falls, however, because of this amount of data, I can't graph more tan 255 columns or rows. does anyone know how I can do this?

 

[Hui]

Can you please post a sample file of maybe 1000 points

 

[greg.begin]

Here is the sample data. Thanks

 

[Hui]

Greg

How do you want that plotted ?

I assume Column A keeps going well above Z1000
What is the relationship of the Column A (Zxx) to the data

Can you post a small picture or sketch showing how you want the data plotted

 

[greg.begin]

Here are the two chart types

 

[greg.begin]

Yes, Column A goes slightly over 243,000

 

[greg.begin]

On this data set, all degrees have at least 1 value

 

[Hui]

360 has no values in the sample file ?

 

[greg.begin]

sorry, you are correct.

 

[Hui]

How about these:



See attached file:

The file contains a macro that converts the data to a single table of 3 Columns
I then added some math to work out the X&Y values and plotted

Enjoy

 

[greg.begin]

Yes! Thank you.

 

[Hui]

You can add more circular axis if you want
Just use the existing ones as a guide

You can run the macro on your data and it will rearrange it for you