Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Chart : X-Y Bar
My Chart look like this :
How can I get the below Chart format.
Output:
in axes tab increase width to 1 both
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
Sorry I was not clear in my first question.
How to get the lines ?
in axes tab increase width to 1 both
Go to chart properties -> Axes Tab -> in Expression Axes and dimension Axis, increase the width of the axis line.