I'm trying to display some data in a graph format for a report. The vertical axis has a $ value the horizontal access lists dates. The report is showing the value of shipments by date for the current month and is meant to be sent daily to sales reps. The goal is to show them how much they are selling each day. Based on that sales data a trend line would show them if they are on target for the month. Right now this is working great when the report runs near the end of the month, but on the first days of the month it can only show the data for the day it runs and any previous days. So, I have one day reported with one bar, then two bars, then three bars ect.
I would prefer, if all business days were shown on the horizontal axis regardless if those days have data or not. They can show as 0 until something ships that day. This way the trend line would be more realistic of what is possible for the month. With only two days in on the whole graph the trend line is very flat. If more days were listed (even as 0) the trend line should more sharply rise.