On a normal line chart...I want to have the horizontal (X) category axis on both the bottom AND the top of the chart. Can this be done? I can place the category axis on the top, or the bottom, but not both. Any advice?
All is complete! The chart uses 2 Y series having cumulative values over time (the X axis). Series A plots across time (X) to a 100% Y axis value. Series B shows progress by % over time in relation to series A. X category values (time) located on both top and bottom scales of the chart was requested for easier plot point identification. I used your advice, but I first created a duplicate series A (making it invisible) and used that to set up a secondary y axis, then go to chart options | axis. I then selected the secondary X and deselected secondary Y for the duplicate series A. This worked perfectly and I did it rather quickly. PaddyD you ARE the MVP!!! Thanks!