I need help with a chart

Copper Contributor

I have some data like this.

Supri03_1-1685848801874.png

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? 

Supri03_0-1685848766809.png

 

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.