Limit Line Chart Labels

[ysiroong]

I want to create a chart that contains all 365 days of the year, but only show the labels for the first day of the month (example below).  Is this possible?

[MK_QSL]

Create Two Expressions

Example:

First Expression : SUM(Sales)

Here Tick Line in Expression Tab and Untick Value on Data Points

2nd Expression : If(Month = 'Jan' SUM(Sales))

Here Untick Line in Expression Tab and Tick Value on Data Points...

[#3]

This might not be apt workaround for you, but you can use vertical axes to mark / differentiate months

[ysiroong]

No.  I don't need to display 2 expressions.  You can ignore the black line on the chart.  I need the chart to display the red line where we can see the different data points for every day of the year, but only show the months as the x-axis label.

[jonathandienst]

Hi

For the expression, click the + sign and enter an expression to return 1 on the first day of the month in the "Show Values" option.

eg - assuming "Date" is the date field and the chart dimension:

     =If(Date = MonthStart(Date), 1, 0)

Make sure the'Values on Data Points' is cleared.

HTH

Jonathan

[ysiroong]

Unless I'm doing something wrong, it looks like this adds the point value on the chart for the first of the month.  I don't want to show that.  I need the x axis to only show the single label for each month, instead of every single day of the year.

Right now, my chart has 365 data points.  The x axis shows 1/1/2013 1/2/2013 1/3/2013 all the way to 12/31/2013.  I only want it to show Jan Feb Mar....Nov Dec, but I need the chart to still the data points for each day.  Just like in the image I attached.