Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
philcud
 
Posts: n/a
Default 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   Report Post  
Jon Peltier
 
Posts: n/a
Default

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   Report Post  
philcud
 
Posts: n/a
Default

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   Report Post  
philcud
 
Posts: n/a
Default

anyone can provide the information requested above?
thanks

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 02:19 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"