Anyone good at Excel. Please help I am trying to plot a graph and have probs with Axis?

Question

I would like to produce a line chart plotting website hits against sales. Hits are in the millions and sales in thousands anyone know how. When I press the chart icon to develop a 2 line graph plotting sales against web hits the sales line is just straight at the bottom. This is so fustrating. Any help would be super.

Answer 1

Create the chart, with the lines showing up wherever they show up.

Once this is done, click into the chart, and then select the line that represents sales. A right-mouse-click will bring up a context-sensitive menu, that should allow you to choose "Format Data Series". From there, select the "Axis" tab, and then click on "secondary axis". This should bring up a second set of numbers on the right side of the chart, with the sales line based on these.

From there, if you need to adjust, you can select the axis, right-click, and go to "Format Axis". If you go to the "Scale" tab from there, you can adjust how big the scale is on the secondary axis.