I have a question about the best way to create a scatter chart. I have three sets of data that has been requested to be put on one graph, and that a scatter chart would be the preferred type.
The catch is that the three sets of data to compare on the chart are on three completely different scales. The x-axis is the date, but the three y-series are in the scale 0-100%, 0-10, and 0-1000. I am having a difficult time resolving the axis so that I don't lose the resolution of each series on the one chart.
An option that I thought was possible was to put two of the series on the same axis but have two different data labels for that axis, and then use a secondary axis for the other. I am using Excel 2003 and I just cannot find the option to do that. Can anyone please point me in the right direction or give me a work around to accomplish this type of graph with this type of data? As a side thought, would it also be even possible to have three different scales with three different axis labels on the primary axis?
Thanks very much!
The catch is that the three sets of data to compare on the chart are on three completely different scales. The x-axis is the date, but the three y-series are in the scale 0-100%, 0-10, and 0-1000. I am having a difficult time resolving the axis so that I don't lose the resolution of each series on the one chart.
An option that I thought was possible was to put two of the series on the same axis but have two different data labels for that axis, and then use a secondary axis for the other. I am using Excel 2003 and I just cannot find the option to do that. Can anyone please point me in the right direction or give me a work around to accomplish this type of graph with this type of data? As a side thought, would it also be even possible to have three different scales with three different axis labels on the primary axis?
Thanks very much!