View Single Post
  #1   Report Post  
Rebekah
 
Posts: n/a
Default can't change how data on 2nd axis is being displayed

I have created a chart with columns on 1 axis and lines on the other. My
problem is that I want to show the information on the 2nd axis in correlation
to the information that is being displayed on the primary axis. For example,
my data for the primary axis is Revenue by Market Segment by Year and the
data on my secondary axis is Number of Sales Order by Market Segment by Year.
What I am trying to do is so the data point for the Number of Sales order
for a particular year in the same place as the revenue for the particular
year and market segment is being displayed on the primary axis. Is there a
way that I can force my data to do this on the secondary axis. Any help is
appreciated.

Rebekah