Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Line chart series to start @ 0

Status
Not open for further replies.

codecomm

Programmer
Feb 14, 2007
121
US
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).
Right now, the chart line starts at the January amount, say $10,000 for example for the first month data value.

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!
 
Right-click the y-axis. Click axis properties. The first tab to open should be "Axis Options." There is a drop-down halfway down the screen which says "Minimum." Add a 0 in that box.
 
Thanks RiverGuy!

That just did the same thing as the margin property.
It just added a left margin more or less.

The left to right flow is by month, and the vertical is dollar values.
 
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.
 
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top