Limit the x-axis date values

[#1]

Hi,

I have a line chart with date (MM/DD/YY) as x-axis dimension.

we have data for current 12 months, it shows all 12 months in the chart, but i want to show only 6 months from that as a label in x-axis but it should show 12 months data in the chart (alternate Month dates should be shown in the chart).

How we can achieve it?

[sushil353]

here is the trick.

go to your dimensions and click on + sign..

click on text color..

there you can define condition like this:

=if(month='jan' or month='march',red(),White())

HTH

sushil