ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   XY scatter and Bar chart - secondary axis misaligned (https://www.excelbanter.com/charts-charting-excel/38444-xy-scatter-bar-chart-secondary-axis-misaligned.html)

philcud August 3rd 05 04:02 PM

XY scatter and Bar chart - secondary axis misaligned
 
hi all,
i am making a gant chart, with stacked bar chart (using hidden series).
x axis (bottom) is date, y axis (left) is task name (ie category axis).
i have overlayed an xy scatter (i had an extra column giving the
vertical coordinates for the scatter, 0.5 1.5 etc, y coordinates are
dates) , which has worked fine when i had 4 categories.
however, when i include all needed categories (28), the secondary y
axis (right) disappears, and the scaling changes so that the vertical
alignment of the xy points is misaligned.
i have tried everything to show the secondary y axis so i can change
scale, but no luck - any ideas please.
thanks.



All times are GMT +1. The time now is 09:35 PM.

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