| Author |
Message |
bal1
Groupie
Joined: 28 Nov 2012
Online Status: Offline
Posts: 44
|
   Topic: Numeric Date/Line Graph
Posted: 24 Jan 2013 at 9:34am |
|
Hi,
I have a Numeric Line graph that uses Dates for the x/group axis. The data for the graph is 'for each record' = date, and the values pulled in are the Results for each date.
By default, the group axis displays each individual date, but this is far too many. I would like to just show a range.
For example, if I have 1 result for each day of the month, I do NOT want 30 date labels in my X-axis, I would rather have about 3: the first of the month, the 15th, and the 30th.
Can anyone help with this?
Thanks!
|
 IP Logged |
|
|
bal1
Groupie
Joined: 28 Nov 2012
Online Status: Offline
Posts: 44
|
Posted: 29 Jan 2013 at 2:02am |
|
Can anyone help with this? I'm really stuck.
Thank you
|
|
IP Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 29 Jan 2013 at 4:15am |
|
are you only interested in changing how the labels appear?
|
|
IP Logged |
|
bal1
Groupie
Joined: 28 Nov 2012
Online Status: Offline
Posts: 44
|
Posted: 29 Jan 2013 at 5:34am |
|
Yes, right now the x labels are showing individual dates for each data point in Y axis.
This is way too many.
I'd rather show maybe 3 or 4
Ex: Jan 1 Jan 15 Jan 31
But it would have to be flexible if my data spans a month and a half for example:
Jan 1 Jan 20 Feb 1 Feb 20, etc
I don't mind if the # of labels is fixed, as long as they scale to the data set in Y
|
|
IP Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 29 Jan 2013 at 6:27am |
not exactly what you want but try this ( I am on version XI)
click once on any axis x field
right click and select 'group axis (x) options'
select layout
mark 'skip group labels' as true and enter a value in the box like 15. This would show a label every 15 days (group) if you have a value per day.
|
|
IP Logged |
|
bal1
Groupie
Joined: 28 Nov 2012
Online Status: Offline
Posts: 44
|
Posted: 29 Jan 2013 at 6:34am |
|
Could be close to what I want but it's grayed out
I'm on XI as well
|
|
IP Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 29 Jan 2013 at 6:37am |
|
'Show Axis Labels' must be true which activates the 'skip group labels'
|
|
IP Logged |
|
bal1
Groupie
Joined: 28 Nov 2012
Online Status: Offline
Posts: 44
|
Posted: 29 Jan 2013 at 6:41am |
|
Hmmm..yeah, that's not working.
I even tried resetting them.
Could it be because of the chart I selected or the way my data is setup?
|
|
IP Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 29 Jan 2013 at 6:45am |
Maybe.
I did not have any problems with different chart types...?
|
|
IP Logged |
|
|
|
