Smart questions
Smart answers
Smart people
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

Join Tek-Tips
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

LINK TO THIS FORUM!

Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site
Partner Button
(Download This Button Today!)

Feedback

Thanks so much for having a place for us propeller heads to hang out and chat.

Geography

Where in the world do Tek-Tips members come from?
codecomm (Programmer)
31 Jan 11 15:08
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!
RiverGuy (Programmer)
31 Jan 11 15:34
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.
codecomm (Programmer)
31 Jan 11 15:40
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.
codecomm (Programmer)
1 Feb 11 9:22
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.
 
codecomm (Programmer)
3 Feb 11 13:57
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.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close