Excel chart not showing all data selected

Question

Although I have all data selected, the last month will not display in the chart.  I was able to get the last month's title on the chart, but not the data point.

A closed post suggested editing the Minimum and Maximum bounds under Format Taskpane to fix this problem, but those options do not appear to exist in Office 2016.

Answer 1

Could you create a stripped-down copy of the workbook (without sensitive information) and make it available through one of the websites that let you upload and share a file, such as OneDrive, Google Drive, FileDropper or DropBox. Then post a link to the uploaded and shared file here.

Answer 2

File available here (had to use a different account to post).

Answer 3

That's a very weird chart - it doesn't show anything resembling a chart on my computer (Excel 2019 on Windows 10), and editing it makes all contents disappear completely.

Moreover, the Goal series hasn't been set up correctly - its data are in a column while the x-values and y-values for the Repeat Missed Goals series are in a row,

So I added values for the Goal series below that for the Repeat Missed Goal series, and created a new chart from scratch.

See https://www.dropbox.com/s/pkx2qrrff41hx0o/Postable%20Root%20Cause%20Workbook.xlsx?dl=1

Answer 4

Thank you!  I implemented the goal line based on an MS post.  I didn't know it needed to be on the same axis as the rest of the data.

By the way, how did you get the chart tab to display nothing but the chart, i.e., no gridlines outside the chart?

Answer 5

I didn't do anything special - I simply set the y-values for the series to D26:O26 and D27:O27, respectively, and the x-values to D1:O1. You can see this by activating the chart sheet and clicking Select Data on the Design tab of the ribbon.