Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
solwebsolutions
Starting Member
5 Posts |
 Posted - 2011-01-31 : 15:12:52
|
| 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! |
|
|
kiruthika.P.
Starting Member
5 Posts |
Posted - 2011-02-01 : 02:23:30
|
| can u be more clear plz.kirthi:) |
 |
|
|
solwebsolutions
Starting Member
5 Posts |
Posted - 2011-02-01 : 09:16:11
|
| Let's say I look at three months:January @ $10,000February @ $15,000March @ $12,000The category fields (on the horizontal) are the months, and the data fields (what builds the vertical axis) is 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. |
|
|
|
andydexster
Starting Member
7 Posts |
Posted - 2011-02-01 : 13:35:43
|
| Hi,you can go to Axis properties-> in the Axis options page go to set axis scale and style-> set the minimum to '0'.andy |
|
|
|
solwebsolutions
Starting Member
5 Posts |
Posted - 2011-02-02 : 00:02:50
|
| Hi!Tried that for the minimum, but it didn't work.I'm wondering about maybe using some different data for the horizontal axis. |
|
|
|
kiruthika.P.
Starting Member
5 Posts |
Posted - 2011-02-03 : 06:18:02
|
| hi If u make right click in horizontal axis and go for Axis Options ---> side Margins --->disabled,here you can make the line start from the vertiacal axis corresponding to the value in the x axis , but i too don know how to make line start @0 and next to 10000 for jan.kirthi:) |
|
|
|
solwebsolutions
Starting Member
5 Posts |
Posted - 2011-02-03 : 09:10:25
|
| yes...side margins are disabled... |
|
|
|
solwebsolutions
Starting Member
5 Posts |
Posted - 2011-02-03 : 13:59:37
|
| 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. |
|
|
|
|
|
|
|
|
Line chart series to start at 0