• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

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

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?
 
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
 
How about these:
upload_2015-2-1_12-40-55.png
upload_2015-2-1_12-41-13.png

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
 

Attachments

  • Sample points Hui.xlsm
    183.6 KB · Views: 8
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
 
Back
Top