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
Great! Achieved after making bar distance Zero in Presentation tab.
One more thing! In expression tab, if i check 'values on data points' in first sum(sales) expression, it's giving correct. But if I check the same for 2nd TOTAL expression, it's giving three totals, though i need one. for example, in Jan month, I need 620 on top of gray bar.
Thanks a lot! dear.
BR,
SAK
Yahoo! done.Sundarakumar Kalaimani
I used Combo chart. First two expressions with bar. third expression with symbol (plus) with formula SUM(TOTAL<Month>Sales).
But if you have one product selected in the list, the lining up of two 'Values on Data points' was not good as pointed by Steve Dark.
However, to avoid lining up issue I made third expression conditional as =GetSelectedCount(Product)=0 or GetSelectedCount(Product)>1.
In the end, it all worked great.
Thanks a lot!
In presentation tab, unchecked pop-up labels, as really there is no need for it as everything is labelled itself - month, product name, each product monthly sale, and total monthly sale; otherwise natural pop up does not look proper (especially for 2nd expression).
You are welcome