ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Secondary axis only? (https://www.excelbanter.com/charts-charting-excel/133647-secondary-axis-only.html)

JICDB

Secondary axis only?
 
I am using Excel to create a dashboard report and therefore the graphs are
really close together. The graphs are line graphs and I wanted to alternate
the side in which the axis shows up so it doesn't clutter the page. Is there
a way to move the Y axis to the right side on some grahs instead of on the
left or do I have to create a secondary axis where the primary has no data.

MartinW

Secondary axis only?
 
Hi JICDB,

Double click on the X axis values then on the scale tab
check 'value (y) axis crosses at maximum category'

HTH
Martin



JICDB

Secondary axis only?
 
Awesome! iT worked great! Thanks!

"MartinW" wrote:

Hi JICDB,

Double click on the X axis values then on the scale tab
check 'value (y) axis crosses at maximum category'

HTH
Martin





All times are GMT +1. The time now is 06:45 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com