×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Insert Statistic Chart

Insert Statistic Chart

Insert Statistic Chart

(OP)
I'm trying to make a histogram of some QC date in Excel 2016. The MS online help says to select the data and Click Insert > Insert Statistic Chart > Histogram. I don't have any "Insert Statistic Chart" option on the Insert tab. Alternatively, you are supposed to be able to pick Insert > Charts > All Charts > Histogram but I have no Histogram option in All Charts. I tried loading the Analysis ToolPak in Addins but that didn't seem to make any difference. And yes, I rebooted but that made no difference either.

----------------------------------------

The Help for this program was created in Windows Help format, which depends on a feature that isn't included in this version of Windows.

RE: Insert Statistic Chart

On mine, as Greg, then click the All Charts tab, rather Recommended Charts, which is displayed by default.

Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/

RE: Insert Statistic Chart

Alternatively there is a "Statistics Charts" icon in the Charts group on the Insert tab.

Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/

RE: Insert Statistic Chart

(OP)
I don't have a statistics chart option. And none of those icons give me a statistics chart option.

----------------------------------------

The Help for this program was created in Windows Help format, which depends on a feature that isn't included in this version of Windows.

RE: Insert Statistic Chart

In digging around - one suggestion is to turn off "Compatibility View" which does make sense. If it cannot save the new chart format it won't let you create one.

RE: Insert Statistic Chart

(OP)
THANKS! It was an .XLS file, I saved it in .XLSX and now I have the histogram graphs. I had to save, exit Excel and restart but it's there.

----------------------------------------

The Help for this program was created in Windows Help format, which depends on a feature that isn't included in this version of Windows.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members! Already a Member? Login



News


Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close