Philip_Loughborough
New Member
- Joined
- Apr 11, 2020
- Messages
- 4
- Office Version
- 365
- 2010
- Platform
- Windows
Dear all
I have a complex chart using multiple chart types and two vertical axis. The left (main) one is the key data, the right (secondary axis) are control signals. One of these, signal, is the grey bars which are meant to be 'at the back', however they insist on being at the fron. Setting transparency, as done here, has not helped as it alters the underlying colours below.
I've sort of found charts on the secodary axis are infront of charts on the primary. So I can solve this by putting my main charts on secondary and the control signals on primary.
Here the control signal is at the back, where I want it, and the colours on the main chart are not effected.
Now, however, I'm faced with the non-conventional main data axis on the right hand side!
Does anyone know if you can resolve all of this in a different way. There appears to be no way of changing the object order of an indivual chart.
Many thanks
Philip
I have a complex chart using multiple chart types and two vertical axis. The left (main) one is the key data, the right (secondary axis) are control signals. One of these, signal, is the grey bars which are meant to be 'at the back', however they insist on being at the fron. Setting transparency, as done here, has not helped as it alters the underlying colours below.
I've sort of found charts on the secodary axis are infront of charts on the primary. So I can solve this by putting my main charts on secondary and the control signals on primary.
Here the control signal is at the back, where I want it, and the colours on the main chart are not effected.
Now, however, I'm faced with the non-conventional main data axis on the right hand side!
Does anyone know if you can resolve all of this in a different way. There appears to be no way of changing the object order of an indivual chart.
Many thanks
Philip