Generate an Excel Chart with Two Y axis

[FINNNNNNNN (Cfm6735)]

Dear Forum,

I want to generate a chart which has two Y axis,
the Sample Data contains the Price and Ranking of two Items,
Please help to make the Data turn into chart.

thank you!
ChartWithTwoYaxis-SampleData.xlsx (9.8 KB)

[Anil_G (Anil Gorthi)]

@FINNNNNNNN

I dont think any activity can help you with it…you need to go with creating a macro and invoke it

Cheers

[vrdabberu (Varunraj Dabberu)]

Hi @FINNNNNNNN

Please check the below attached files:

ChartWithTwoYaxis-SampleData 1.xlsx (12.6 KB)
ChartwithtwoYaxis 1.txt (2.5 KB)

Regrds

[FINNNNNNNN (Cfm6735)]

Thank you it’s work!!