Profile Picture

Scale Data Labels same as x-axis major ticks (line chart)

Posted By Alan Hubbard 10 Years Ago

Scale Data Labels same as x-axis major ticks (line chart)

Author
Message
Alan Hubbard
Posted 10 Years Ago
View Quick Profile
Forum Newbie

Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: Forum Members
Last Active: 10 Years Ago
Posts: 5, Visits: 28
Hi

I'm using a Scatter XY line chart with three values vs time-category lines. The primary x-axis labels are scaled to show years only (see first attachment) and formatted the same (Values Grouping Editor -> Label: =Format(Fields!Date.Value,"yyyy"))

How do I group the Data Labels to display only on the Major Ticks (only years).
Attached is
1. Primary X Settings to group major ticks by year
2. chart with all data labels showing for one value line
3. settings attempt to group data labels by year, but not working



Nevron Support
Posted 10 Years Ago
View Quick Profile
Supreme Being

Supreme Being (4,435 reputation)Supreme Being (4,435 reputation)Supreme Being (4,435 reputation)Supreme Being (4,435 reputation)Supreme Being (4,435 reputation)Supreme Being (4,435 reputation)Supreme Being (4,435 reputation)Supreme Being (4,435 reputation)Supreme Being (4,435 reputation)

Group: Forum Members
Last Active: Last Week
Posts: 3,054, Visits: 4,009
Hello Alan,
It seems that the attachments are missing. Can you try re-adding them?

Best Regards,
Nevron Support Team



Alan Hubbard
Posted 10 Years Ago
View Quick Profile
Forum Newbie

Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: Forum Members
Last Active: 10 Years Ago
Posts: 5, Visits: 28
Hi 
I solved the previous issue by using the settings under Axis -> Scale -> Numeric Tab -> Step Mode "custom" -> Custom Step "Year". (only saw your reply recently, so apologies).

I have another issue you may be able to help with. I'm still using the xy scatter and grouping on effective date to give the following graph:
https://www.nevron.com/forum/uploads/images/00679be3-ed08-47ee-bf70-1914.png

with these settings:
https://www.nevron.com/forum/uploads/images/bb975f9d-6e20-4692-9cfa-7126.png

The problem is the space before the 2011 label. This happens because the data starts late in the year and the step is by "year". The client wants the label next-to the y-axis with no space before. I've tried changing the custom step to "month", but then each month has it's own label:
https://www.nevron.com/forum/uploads/images/fe7df5e6-d88d-44ce-9046-bc99.png

I've also tried formatting the label with "=IIf(Month(Fields!EffectiveDate.Value) mod 12 = 0, "yyyy","")", but no success.
Any ideas?

Alan Hubbard
Posted 10 Years Ago
View Quick Profile
Forum Newbie

Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: Forum Members
Last Active: 10 Years Ago
Posts: 5, Visits: 28
Found the solution. Keep custom step in 1 year units and add a "Begin" under the Range tab. The reason it didn't work before is because the begin date needs to be formatted. =First(Fields!EffectiveDate.Value, "Dataset") does not work, but this does: =Format(First(Fields!EffectiveDate.Value, "Dataset"),"yyyy-MM-dd")



Similar Topics


Reading This Topic