is it possible to create a chart with secondary y-axis using PHPExcel?

[simkimsia]

I manage to create chart using PHPExcel.

But I was not able to create one with secondary y-axis.

Please advise.

[MarkBaker]

At this point in time, PHPExcel doesn't support secondary axes in charts

[simkimsia]

Understood.

Thank you.

Please continue the great work you have with PHPExcel! It is awesome!!

With gratitude, KimSia 金城

On Tue, Jan 29, 2013 at 6:54 PM, Mark Baker [email protected]:

At this point in time, PHPExcel doesn't support secondary axes in charts

— Reply to this email directly or view it on GitHubhttps://github.com/PHPOffice/PHPExcel/issues/134#issuecomment-12829487.

[jeremyferrett]

Hi Mark Thanks for the project it really is handy for reporting. Is there any plan to implement secondary axes any time soon? Jeremy

[ConAntonakos]

Hi Mark,

Any update on this?

Thank you for this incredibly awesome library.

[lynxtdc]

Hey Mark:

Any update on being able to add a secondary y-axis to a chart?

Thanks again for your work on this library

[eisberg]

Hi Mark,

Any update on this? :D

[raisen]

I'm looking for this feature as well. Any updates?

[akelalix]

Hi all, i'm also looking for the secondary axis feature.. any updates ? thank you

[betocantu93]

Hi Mark,

Any updates? I'm looking as well.... Thanks

[harrati]

Hi Mark,

I really appreciate this great library, And I'm using it for almost all projects where I have to deal with Excel files. For my actual project I really need this secondary y-axis feature could you please provide me an alternative for this?

yours, sincerely.

[betocantu93]

If you give the data in a certain way, Excel will do it for you, maybe this tut can help you on how you should give the data, in phpexcel you could just then select all this data and excel will do the trick, this worked for me in a secondary x level... Here is the tut http://excelribbon.tips.net/T001188_Two-Level_Axis_Labels.html

[eisberg]

Also I look forward to! Tell me what the problem is with the implementation of this feature?

I think you need to take, and to resolve this issue!

[Porrapat]

Hi, here, secondary axis chart on PHPExcel.

It's long time but my work required it. So I created this one. To give it back to community so I have to make pull request back to the original code.

https://github.com/PHPOffice/PHPExcel/pull/1037

Thank you again.

[anr-isu]

Hi I'm trying to get the solution Porrapat has made to work in Laravel 5.3 using PHP 5.6.23. But I unfortunately, I cannot get it to work - I'm not sure if it's only me who has merged it in wrong or if it only work for older versions

But it would be great if his solution could be implemented!

[Porrapat]

I have tested it on PHP 5.4.7.

[Porrapat]

This one will be useful to help me test it. http://officeopenxml.com/anatomyofOOXML-xlsx.php

Thank you.

[TrieBr]

@Porrapat Excellent patch (#1037)! This just saved me. Works great on PHP 5.6.28.

Thank you!

[Porrapat]

@TrieBr Happy to hear you can solve the same problem we face.

Thank you to you too!

[KishanPatel007]

Thank you for save my time.

With help of this https://github.com/PHPOffice/PHPExcel/pull/1037 patch i have created successfully secondary Y axis But now i have faced one problem is set custom secondary Y axis plot means i want to set custom start point , end point and plot interval for secondary Y axis.

Is it possible in PHPExcel 1.8.1 ?