bar chart

[mambi]

Hi everyone,

from the sample data below ,

Month	Prod	Stock
Feb	A	10
Feb	B	20
Feb	C	30
Feb	D	40
Mar	A	20
Mar	B	39
Mar	C	34
Mar	D	23

i created this bar chart :

and now i want to know if it's possible to add a fifth (horizontal) bar to the chart (same chart) for the average ( Month : feb )

Thanks

[#2]

Will this do?

Thanks,

Prabhu

[mambi]

i know this method but i want to add a horizontal bar

[MayilVahanan]

Hi

There is no option in bar chart. You can use the reference line

And increase the weight as per attached file

[#5]

Chk it out

test:

LOAD * INLINE [

    mon, Prod, Stock

    Feb, A, 10

    Feb, B, 20

    Feb, C, 30

    Feb, D, 40

    Mar, A, 20

    Mar, B, 39

    Mar, C, 34

    Mar, D, 23

];

Concatenate

load mon, 'Avg' as Prod, avg(Stock) as Stock

Resident test

Group by mon;

Thanks,
Prabhu

[MK_QSL]

Like below... Please confirm... i will upload the trick...

Also, confirm which edition you are using ?

i.e. Licensed or Personal...

[#7]

Please mark it as correct answer if the solution provided is suitable for you.

Thanks,

Prabhu

[mambi]

is there any method to get the same result using chart expression not in the load script ?

thnaks

[mambi]

thanks for your help but the results seems to be wrong !

[MK_QSL]

What could be the result?

Kindly let me know, I will check and confirm back...