Chart missing client name as legends

Laura G

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

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

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.