Home |
Search |
Today's Posts |
#1
|
|||
|
|||
XY scatter and Bar chart - secondary axis misaligned
hi all,
i am making a gantt 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. |
#2
|
|||
|
|||
Choose Chart Options from the Chart menu, click on the Axes tab, and
select the combination of axes you need. Here's more on the Gantt chart: http://peltiertech.com/Excel/Charts/GanttChart.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ philcud wrote: hi all, i am making a gantt 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. |
#3
|
|||
|
|||
unfortunately, the axis options are greyed out for all series.
i am attempting to rebuild the chart and see at what stage the option to assign axis to a series is lost. have looked in the newsgroup and it seems as though the order in which series are added / amended affects the chart - is there anywhere i can view such information in detail? |
#4
|
|||
|
|||
anyone can provide the information requested above?
thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|