Bar Chart with Static X Axis (Months)

[#1]

I have a table of data

SalesGuy	Date	Sales
Person A	1/1/2012	59
Person B	1/2/2012	32
Person C	2/1/2012	423
Person A	3/1/2012	234

etc

I have a bar chart which shows the total sales for each month, with Month(Date) as the Dimension, and Sum(Sales) as an expression. It looks good!

But I want this chart to change when i click a ListBox of my SalesGuys, so it shows the clicked persons sales. Problem is, if SalesGuy A doesnt sell anything in March, the months will redraw as JFAMJJASOND, when I want JFMAMJJASOND and 0 for March. Its not obvious that the month has been omitted.

Hoe can I fix this, to force all months to be shown?

I have tried "Show All Values" and Surpressing nulls etc with no luck.

Thanks in advance.

[#2]

Try Unchecking "Suppress Zero-Values" under Presentation tab. Thats the only other thing I can think of.

Cheers

[#3]

Hi,

See attached, is this what you are looking for ?

In addition to what Sandeep recommends you also need to check "Show all values" check box for the dimension.

Best Regards,

[jagan]

Hi,

Unchecking "Suppress Zero-Values" in Presentation tab works perfect.

Regards,

Jagan.

[#5 · Accepted solution]

I fixed it, perhaps it was a basic question.

I had to add Month(Date) as OffMonth to the script. Using that as my dimension, as opposed to Month (Date) works fine.

[#6]

Hello, I know this is a older post, but I have a Question.

When I try to use a average trend line in your archive, this is the result:

Why this happens?, the total result is divided by 4 and not by 3 (January, February, March).

Is there a way that takes only the number of values ​​that really exist?.