How to show Actual & Budget in same scale

[arethaking]

Hi All,

I want to show the bar chart actual and budget as shown in the picture.

Please help me.

DATA:

LOAD * INLINE [

Product,SALES,BUDGET

P1,17,43

P2,3,15

P3,4,7

P4,4,6

P5,5,4

P6,5,2

];

[Digvijay_Singh]

I think By default it shows both in same scale, can you elaborate further, I don't have licensed version to open qvw but tell me exactly what do you want in your sample -

[arethaking]

Hi digvijay

For P1 , I want to show max scale 43 for actual and budget.But you have shown 60. Please check my screen in post.

[vardhancse]

Hi,

When we are using "Stacked bar chart" then by default both will be merged and will show the values in one single bar charts with different color's.

So if you want to see the separate scale then change the chart type to "Grouped"

[Digvijay_Singh]

You may play with the scale by adding formulas in the static max, steps in Axis tab, something like this -

[Anil_Babu_Samineni]

You have values like 17+43 = 60. I am not sure, Why you need 50 for Y-Axis. Does it make sense. For me it's not because if we are not showing the data points then how customer thinks what is the value. They always think 50 only even 60 is there. If not, May be elaborate more