Trend line?

[#1]

Hi,

I have a requirement where i need to show the trend line of Revenue over the years.

Ex:

year, Rev

2011,0

2012,0

2013,2

2014,4

when i had this data on chart, trend line only shows for 2013 and 2014, but i want it to show from 2011 to 2014 i.ee line from 0 to 4.

Is it possible?

Thanks

[stigchel]

Zero values are being suppressed, in the presentation tab of the properties uncheck the suppress values checkbox

[sunny_talwar]

Is this the requirement?

If yes then just uncheck -> Suppress Zero-Values on the presentation tab

[#4]

Thanks,

But for the data its not letting me do that.

PFA

[sunny_talwar]

But for the data its not letting me do that.

What data are you referring to? Nothing is attached?

Best,

Sunny

[#6]

Sorry PFA

[sunny_talwar · Accepted solution]

Used a CrossTable load to first fix the data in a structure which can be used easily:

Table:

load * inline [

ID, Jan,Feb,Mar,Apr,May,Jun,Jul

1,0,0,0,0,300,400,0

2,0,500,600,700,0,800,0

3,0,0,0,0,0,800,900];

Table1:

CrossTable(Month, Data, 1)

LOAD *

Resident Table;

DROP Table Table;

And then replicated the chart we had initially:

[#8]

HI,

Any idea how to have $ sign on Y axis?

I changed the format to money in number tab, but still its the same.

Thanks

[sunny_talwar]

Does this work?

Added it on the Numbers tab:

HTH

Best,

Sunny

[#10]

Thanks,

But can we have $ sign next to all values on Y axis?