Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations SDETERS on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Insert Statistic Chart

Status
Not open for further replies.

dgallup

Automotive
May 9, 2003
4,715
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.
 
Replies continue below

Recommended for you

On my version it is insert, then in the lower right hand of the charts section there's a weird little icon, hit that for a list of all charts including histogram



Cheers

Greg Locock


New here? Try reading these, they might help FAQ731-376
 
for those visually oriented folks
histochart_soau54.png


TTFN (ta ta for now)
I can do absolutely anything. I'm an expert! faq731-376 forum1529 Entire Forum list
 
I don't have a statistics chart option. And none of those icons give me a statistics chart option.
Capture_afvp09.jpg


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

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.
 
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.
 
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor