After combine chart 1 and 2 into one chart i can only see chart 2 bar.

[paulyeo11]

Hi All

I have  :-

Chart 1 a line chart YOY

Chart 2 a sales by year

When i combine both chart into 1.

I am unable to see the line chart YOY i can only see the Bar chart sales by year,

Paul

[paulyeo11]

My QVW

[adamdavi3s]

Hi Paul,

Change the axes of one of your expressions to be left

[paulyeo11]

Hi Sir

Thank you very it work.

Paul Yeo

DIrector

TDS Technology (S) P/L

Whatsapp +65 9326 1804

www.tdstech.com<http://www.tdstech.com>

[paulyeo11]

Hi Adam

May i know how to make the line color to red color , ( now line and bar color are same ) .

Paul

[adamdavi3s · Accepted solution]

on the expression tab, expand the expression and under Background colour just type in red() or lightred()

Please remember to mark this as helpful or the correct answer if I have helped you or answered your question.

This will help users identify the answers should they come across this thread in the future.

[paulyeo11]

Hi Adam

Thank you it work fine now.

Paul

[paulyeo11]

Hi All

May i know how to make the legend for Total Sales square box shown Red color ?

How to make the Left  Y Axis display word Total sales ? and Right side Y Axis display YOY ?

Paul Yeo