Forum Discussion
Excell charts
I need to build a chart with two linear graphs based on the horizontal axis with two scales. Can somebody advise me how to do it or rather build a chart for me based on my data and explain later?...
Create a standard line chart, then select one of the series and specify that it should use the secondary value axis. Change the scale of the secondary axis as needed.
Thank you. I did it. However, as a result I am getting two vertical axes (left and right) instead of two horizontal axes (top and bottom). Having two vertical axes help but not sufficiently. May I send you the actual data so you may try yourself?
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar? Alternatively, you can attach it to a private message to me. Thanks in advance.
- Thank you, Hans. I prefer to send a private message to avoid getting multiple responses. However, I don't see how I can do it from this format. There is no option which would allow me to attach a file.
Could you share your email with me? I am a retired engineer in the USA. The chart I am talking about is for my article being readied for the Tribology Transactions. My email: email address removed for privacy reasons. Regards.I have received your email and replied to it.