I need help with a chart

Copper Contributor

I have some data like this.


I need to make a plot to show how the InsuredValue varies with Region. So I made a plot.

But there are repeated values on the x-axis.

The region column only has 4 values : East, Central, Northeast, Midwest. I want only these four values on my x-axis. How do I solve this? 



1 Reply

@Supri03 Plot the InsuredValues column and point the horizontal axis labels to the Region column. The latter you do on the Chart Design ribbon, with Select Data.

I have attached a simplified example.