Chart is showing non existent data at the front

**PastorMike** · 02-07-2022, 01:55 PM

I've created a Combo Chart is an Access Report and there is a bar at the beginning of the chart representing data that does not exist. I can't get it to go away.
Screen shot as follows:

**pbaldy** · 02-07-2022, 02:05 PM

Fyi your attachment failed, you might try again. Make sure the chart's source doesn't have the mystery data.

**PastorMike** · 02-07-2022, 02:13 PM

Thanks for the quick reply!
I'll try the attachment again...

**June7** · 02-07-2022, 02:48 PM

If you want to provide db for analysis, follow instructions at bottom of my post.

**PastorMike** · 02-07-2022, 03:06 PM

Spreadsheet and Access DB zipped and attached. I GREATLY appreciate your assistance!!

**June7** · 02-07-2022, 03:12 PM

Why is there is no chart in report?

Strongly advise not to use spaces nor punctuation/special characters in naming convention.

**June7** · 02-07-2022, 03:20 PM

Sorry, duplicate post.

**CarlettoFed** · 02-08-2022, 02:19 AM

Highlight which bar is at the beginning of the chart that represents data that does not exist.

**Welshgasman** · 02-08-2022, 07:17 AM

You have 10279 for record 20 with no date?

**PastorMike** · 02-08-2022, 07:40 AM

Great catch - THANK YOU!
I had the last line as a running total and didn't even think that it would try to chart it. Wow - thanks!

Chart is showing non existent data at the front

Thread Tools

Chart is showing non existent data at the front

Similar Threads

MS-Access Forms showing in background instead in front

Chart for showing with text type data and number data

Chart is not showing up on the report.

line chart not showing lines

Design view not showing data (Pivot Chart)

Posting Permissions