Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Dual axis chart

Hi all,

I have a requirement to use a dual axis chart with Budget,Spent and Variance. Variance should be in a line and the expecatation was to use something like a bullet chart format to show budget and spent, that is we want to show out of the budget , how much is spent and this can be claerly shown in bullet format.

As there is no vsual with bullet and line together, I have used column and line chart,but this looks crowded when the data labels are turned on.

Is there a way I can turn on data labels for only variance and turn it off for budget and spent?

Or please suggest if there is a visual with bullet and chart.

Thank you

Poojitha