Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
Is this type of chart possible? Blue is Product 'A' sales and Green Product 'B' sales, whereas Grey is total sales.
BR,
SAK
Hi Shoaib,
Please go to the chart properties---->>> Under Style Tab you can try this by changing Top Angle and Side Angle Dimensions.
Thanks,
AS
Not exactly matched your requirements but tried to go near..
Please check enclosed file..
UPDATE : Bit more near... check 2nd file..
HI,
See the attachment.
Hello Tech Geniis,
need your precious guidance.
Thanks and best regards
SAK
Please take a look at the chart. May be two charts with transparent mode can bring such visualization.
Whilst layering transparent charts is possible it tends to get very confusing very quickly - and sometimes the lining up fails.
You could use a combo chart and put a symbol above the bars to show the total (you would need to use the TOTAL <Dim> syntax to ignore the second dimension). Another way to achieve similar may be to have a stacked bar, where you have the DimValue as one expression then the Total (using TOTAL again) less the dimension value as expression two then stack them. I'm not sure whether stacked bars and multi dimensions play nicely together though.
It's always worth trying to push back to the end user to get them to have something a bit more standard, if you can.
Steve
Hi,
I have edited Manish's Chart a little it and it looks exactly as what u want..
Pls check
-Sundar
Hi Sundar,
I have PE version. Can you please paste here screen shots.
Thanks
Shoaib
In script
Load * Inline
[
Month, Product, Sales
Jan, A, 200
Jan, B, 300
Jan, C, 120
Feb, A, 420
Feb, B, 360
Feb, C, 220
Mar, A, 180
Mar, B, 300
Mar, C, 420
Apr, A, 600
Apr, B, 400
Apr, C, 220
];
Create a bar cahrt with Month and Product as Dimension
In expression create two expressions
1.sum(Sales)
2. (TOTAL <Month> Sales)-sum(Sales)
for expression 1. background color
If(Product = 'A', Green(),
If(Product = 'B', Blue(),
If(Product = 'C', Red())))
In the color tab keep first three colors as light grey..
-Sundar