I have a line chart series that is for accounting. A sample query would pull back 12 rows (1 row for each month, Jan - December), and the columns would show the dollar amounts for separate buckets of money allocations. What I'm trying to do is have the series chart line start @ 0 (we're trying to mimic another chart that does the same thing). I'm not seeing a property on how to do this...would I need an extra/13th row of 0 values to get the starting point? Thank you!

Hi Bubberz, Can you post the results of the query so that it is easier for us to visualize the issue. Additionally you can follow venkata's approach as well.

Hi Bubberz, Can you post the results of the query so that it is easier for us to visualize the issue. Additionally you can follow venkata's approach as well.

Right Click on Chart and select Axis Properties, have you tried like Miminum=0 and Maximum=12,Interval=1 and Interval Type=Auto. Nanda

Right Click on Chart and select Axis Properties, have you tried like Miminum=0 and Maximum=12,Interval=1 and Interval Type=Auto. Nanda

Just to further explain: Let's say I look at three months time frame: January @ $10,000 February @ $15,000 March @ $12,000 The category fields (on the horizontal) are the months, and the data fields (what builds the vertical axis) are the costs. Right now, when I look at the start of my chart line, it begins @ $10,000 and the request is for it to start @ 0 then go to $10,000 for the month span of January.

Just tried that property setting on the min value, and it just adds a left margin. Here's a sample of data I would get back with five buckets of cost (there are six rows below, the first is the month): Oct 378711 454853.57 417184.2 0 378711 Nov 423265 0 435310.42 0 801976 Dec 378711 -302428.57 403378.81 0 1180687 Jan 445541 552370 0 3909711 1626228 Feb 423265 524750 0 3714225 2049493 Mar 512372 635226 0 4496169 2561865 Apr 467819 579988 0 4105196 3029684 May 467819 579988 0 4105197 3497503 Jun 490096 607607 0 4300682 3987599 Jul 445542 552369 0 3909713 4433141 Aug 512373 635225 0 4496165 4945514 Sep 534649.55 662843.57 0 4691652 5480163.55

Correct me if I am wrong, In X-Axis you are displaying Months(Jan,Feb,March ..... Dec) and in Y-Axis values of five buckets starting 0 to Max value. Right Click on Chart and select Axis Properties, have you tried like Minimum=0 and Maximum=blank,Interval=blank and Interval Type=Auto. In Major Tick Marks set Interval=1 in Set Custom Interval.Nanda

Hi! Yes, the X-Axis and Y-Axis values are correct as you have mentioned. I tried your suggestion, and it just adds a left side margin to the series lines, and puts a label at 0,0 for the month axis. I'm wondering if I need to have a value of 0 for that month to get the line to actually start @ 0. Thank you!

So, I got it to work with the help of a "Periods" look-up table that I created. My main table, which showed the 12 monthly periods, had one column which was a long date-time field. I took that and got the monthname(). With this new look-up child table, I defined an int column ("PKID") from 0-12 (...yes, 13 values/rows) to get the ordering I wanted along with a second column of the month name. For int values 0 and 1, I applied this to the first month, so for January, I had two rows. For my series lines, I had to do an expression that said if the int value of PKID in the look-up table was 0, then the value for the line was 0...hence, I got the lines to start at x,y of 0. From the customers point of view, the January series line looked like it started from 01/31 in the beginning when the report was first developed w/o this PKID field...and they wanted it to really start @ 01/01. For the category (horizontal) axis, I made sure to turn the label off if PKID = 0.