turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- JMP User Community
- :
- Discussions
- :
- Discussions
- :
- Simple bar chart of +250k data points in csv file

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

May 20, 2010 4:32 AM
(979 views)

Fellow JMP Users.

I am new to JMP so I am not sure of what search terms to use in the forum to address the following issue:

I have +250k lines of a .csv file.

Each line has the same type and format of information.

The first value is a decimal number to 3 places of decimals (eg: 23.456)

The second value is an integer value.

I want to graph each first value (on the X-axis) against the its corresponding second value on the Y-axis.

I want the graph to be a bar or line chart so that the user can see the trend of Y value as one goes along the X axis.

1)How should I define the numbers? (ordinal, continous etc)

2)What type of graph should I use for this?

3)I have noticed that graphs in JMP are small. How do I increase the size of these graphs?

Any other information that you think is necessary

Regards

paulsheehan

I am new to JMP so I am not sure of what search terms to use in the forum to address the following issue:

I have +250k lines of a .csv file.

Each line has the same type and format of information.

The first value is a decimal number to 3 places of decimals (eg: 23.456)

The second value is an integer value.

I want to graph each first value (on the X-axis) against the its corresponding second value on the Y-axis.

I want the graph to be a bar or line chart so that the user can see the trend of Y value as one goes along the X axis.

1)How should I define the numbers? (ordinal, continous etc)

2)What type of graph should I use for this?

3)I have noticed that graphs in JMP are small. How do I increase the size of these graphs?

Any other information that you think is necessary

Regards

paulsheehan

4 REPLIES

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

May 20, 2010 8:33 AM
(949 views)

For > 250,000 rows of data I would not use a barchart - way too many bars!

Try using the Graph Builder for a simple line chart. Drag the first column to the X area and the second column to the Y area. Click OK and you're done.

Both columns should be numeric, unless there is some categorical significance to the integers. Then I'd use a different plot/analysis.

To make graphs bigger just click and drag the corner of the graph. If you like a particular sized graph, once you've set the size to something you like, click the little red triangle and select Script > Save Script to Data Table. If you want to run a script outside of the dataset select Script > Save Script to Script Window.

Try using the Graph Builder for a simple line chart. Drag the first column to the X area and the second column to the Y area. Click OK and you're done.

Both columns should be numeric, unless there is some categorical significance to the integers. Then I'd use a different plot/analysis.

To make graphs bigger just click and drag the corner of the graph. If you like a particular sized graph, once you've set the size to something you like, click the little red triangle and select Script > Save Script to Data Table. If you want to run a script outside of the dataset select Script > Save Script to Script Window.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

May 21, 2010 4:54 AM
(949 views)

PMroz,

Unfortunately, I do not have JMP 8 and hence I do not have the Graph Builder.

My version is JMP 6.

After I load my .csv file, I do Graph > Chart.

For the Categories, X, Levels, I specify Column 1.

For the Statistics I specify Column 2. For the statistics I select N.

When I click okay I get a message saying that I am limited to 1000 samples

I know that this is not a simple bar chart, but it is the simplest that I can find

and none of the other charts under Graph seem to apply.

What alternatives do I have?

Thanks

Paul

Unfortunately, I do not have JMP 8 and hence I do not have the Graph Builder.

My version is JMP 6.

After I load my .csv file, I do Graph > Chart.

For the Categories, X, Levels, I specify Column 1.

For the Statistics I specify Column 2. For the statistics I select N.

When I click okay I get a message saying that I am limited to 1000 samples

I know that this is not a simple bar chart, but it is the simplest that I can find

and none of the other charts under Graph seem to apply.

What alternatives do I have?

Thanks

Paul

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

May 21, 2010 7:11 AM
(949 views)

A couple of choices assuming what you described in your original post is what you really want to do:

Make sure both columns are Numeric and Continuous.

1. Graph>Overlay Plot with Column 1 as X and Column 2 as Y and then customize using the red triangle pulldown menu (e.g. add connecting lines, turn off display of points, change plot symbol for points...)

2. Analyze>Fit Y by X with Column 1 as X and Column 2 as Y and then customize using the red triangle pulldown menu (e.g. fit a line or polynomial or smoothing spline, turn off display of points...)

Make sure both columns are Numeric and Continuous.

1. Graph>Overlay Plot with Column 1 as X and Column 2 as Y and then customize using the red triangle pulldown menu (e.g. add connecting lines, turn off display of points, change plot symbol for points...)

2. Analyze>Fit Y by X with Column 1 as X and Column 2 as Y and then customize using the red triangle pulldown menu (e.g. fit a line or polynomial or smoothing spline, turn off display of points...)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

May 24, 2010 5:44 AM
(949 views)

mpb,

Due to time constraints, I have had to generate these graphs in Matlab. The graphs are adequate.

When I need to use JMP again, I will return to your two methods and give these a whirl.

Thank you for taking up this question.

paulsheehan

Due to time constraints, I have had to generate these graphs in Matlab. The graphs are adequate.

When I need to use JMP again, I will return to your two methods and give these a whirl.

Thank you for taking up this question.

paulsheehan