X and Y bar

[suvechha_b]

Chart : X-Y Bar

My Chart look like this :

How can I get the below Chart format.

Output:

[sunny_talwar]

I think you need 2 things here:

1) Sort the bar chart in ascending order based on x axis MonthYear field. Question is, are these dates in dual format? or are they string? I would suggest creating the MonthYear using MonthName() function which will be dual in nature and can be sorted numerically.

2) You need 0 for monthyear where data doesn't exist. For that you will need to uncheck 'Suppress Zero-Values' on the presentation tab of the chart properties.

HTH

Best,

Sunny

[suvechha_b]

Sorry I was not clear in my first question.

How to get the lines ?

[arulsettu · Accepted solution]

in axes tab increase width to 1 both

[#5]

Go to chart properties -> Axes Tab -> in Expression Axes and dimension Axis, increase the width of the axis line.