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
- :
- how do I create a bar chart with a regression line?

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

Nov 20, 2013 9:50 PM
(1080 views)

we want to use an numeric/ordinal column and a numeric/continuous column to populate a vertical bar chart, with the former on the x axis and latter on the y axis

this is amazingly easy in jmp, done in 20 seconds

now we want to fit a regression line to the tops of the bars, ie the data

this is amazingly hard in jmp, cant figure it out -- has to do with the ordinal data on the x axis, but... does this mean it's impossible?

help? thanks

1 REPLY

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

You're right that having a categorical (ordinal) column on the axis is the problem. JMP doesn't want to fit a regression line to categorical data.

However, if you change the modeling type to of your X axis variable to Continuous, you can still plot the bar chart *and* get the regression line.

In the picture below I've changed the modeling type of the Age column in Big Class from Ordinal to Continuous and then created the graph you're looking for.

-Jeff