If you are unable to create a new account, please email support@bspsoftware.com

 

Make nice x-axis labels on my line-chart (when I have a lot of values)

Started by rpostma, 06 Feb 2013 11:54:40 AM

Previous topic - Next topic

rpostma

Hi there!

A question:
I'm working on a linechart in report studio, where I want to show the balance of an account (In total I want a line for 4 accounts) for all records from 2008 until now.

So I have a linechart with
- balance as measure
- account as series (that will be 4 lines in my case)
- date on the categories and nested (below) ID (this nesting is to make sure that the balances are not rolled-up (a sum is incorrect for balances since it is non-additive))

The chart is working OK, but the x-axis looks like one big mess...
Very "unreadable", report studio prints ALL dates (and seems to skip some)...

What I'd like to achieve is
- that the line prints "all points"
- that on the x-axis, for example per yearmonth a value is printed (e.g. 200801, 200802 etcetera) (or if needed per YearQuarter)

How can I achieve that?

A solution that I do NOT prefer is change the query so only per yearmonth or per yearquarter a value exists, since I like to see the line in the lowest detail...

I built a similar chart earlier in highcharts (http://www.highcharts.com/stock/demo/) (where the x-axis and the graph in total is very cool). I don't think that is possible, but something a bit better looking would be great.