› Forums › SPJS Charts for SharePoint › X axis labels
This topic contains 7 replies, has 2 voices, and was last updated by Phil Grant 1 year ago.
-
AuthorPosts
-
February 2, 2018 at 10:26 #19573
Hi,
I have a chart showing a sum of entries by status in a column chart.
I want to have the categories shown in the legend to be along the x axis but can’t figure it out, it only ever shows a numeric scale.Any suggestions?
Attachments:
-
February 7, 2018 at 19:21 #19634
You must add a screenshot of your chart config (basic setup tab where the fields are selected) and also a line from your datasource so I can see how the values look like in the fields you use in the chart.
Alexander
-
February 7, 2018 at 19:44 #19640
Will do tomorrow when I get into work.
-
February 8, 2018 at 10:13 #19653
Here is the info you requested
-
February 10, 2018 at 09:58 #19709
The second column must be specified as “String” and not Number – it isn’t a number and parsing it as a number will fail. If you use “String” it will be counted as 1 if the column is not empty, and as 0 if it is empty.
Alexander
-
February 10, 2018 at 10:12 #19711
I’m sure that I’ve already tried that, I’m not at work at the moment to try it again, when I did that the grouping count doesn’t work and I get hundreds of small bars instead of the few distinct groups.
-
February 10, 2018 at 11:58 #19720
I see, just change order of the fields in the chart config so the one using the title is the first column.
Alexander
-
February 13, 2018 at 09:18 #19789
I eventually got it to work …. sort of, I now have a chart with the right labels but I had to get rid of the ‘split options in separate series’ on the status column but not the ‘colorByLabel’ option no longer works =, I can live with that though.
Attachments:
-
AuthorPosts
You must be logged in to reply to this topic.