Chart missing client name as legends

Hello

I am having issues charting 3 metrics in a scatter chart for our dashboard.

Customer Name - Units required - Year commencing.

My units [MV] are vertical, [COD Start] is horizontal BUT my customer name [Primary Row] is not showing as legends. The plotting is correct and this is how i want to vizualise the data.

Any helps would be great appreciated

Many thanks

Find more posts tagged with

Accepted answers

Genevieve P.

Hi @Laura G

If I'm understanding you correctly, you would like your chart to look more like this:

If so, in order for the legend to pick up your Text labels, these will actually need to be your column headers. I've created the graph above with a set-up like this:

The Year is the Primary column going down, then the Labels I want are the column titles, and the values to plot are in those columns based on the year.

I added in the "-" column with 0 values and no label so that none of the blank cells show as plot points on the graph. I hope this helps!

Cheers,

Genevieve

All comments

Paul Newcome

What does the structure of the data look like that you are using to generate the chart?

Laura G

Hi Paul

thanks for your help. here is the data

Paul Newcome

Try moving the Primary Column to the left of the table and then re-chart the data.

Laura G

Hi @Paul Newcome

Thanks for your tip, I have been moving rows & selecting columns in different orders.

This is what I have landed on. Year (H axis) is correct and MV on (V axis) is spot on.

The scattering is incorrect.

Genevieve P.

Hi @Laura G

If I'm understanding you correctly, you would like your chart to look more like this:

If so, in order for the legend to pick up your Text labels, these will actually need to be your column headers. I've created the graph above with a set-up like this:

The Year is the Primary column going down, then the Labels I want are the column titles, and the values to plot are in those columns based on the year.

I added in the "-" column with 0 values and no label so that none of the blank cells show as plot points on the graph. I hope this helps!

Cheers,

Genevieve

Laura G

This is exactly what i want Genevieve. Thanks for solving this.

Is there any way to omit the 0 values?

Genevieve P.

Hi @Laura G

The blank cells in the other columns will be mapped as 0 - this is why I added the helper column in the front so that I could "cover up" the other colours at the bottom.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.