Aligning Primary & Secondary Axis in Chart

[odarestephen]

Hey guys, little help if you could...

Creating a chart:

Row 1 - Has months of the year
Row 2 - Has numeric values
Row 3 - Shows the percentage each month is of the total of all values in Row 2 e.g. if row 2 totals $1m and March has $200k, row 3 for march will show 20%.

The problem:

When I create a line chart, I align the values to the Primary Axis and the percentages to the Secondary Axis this however, this creates 2 lines on the same chart. This is because the each chart is lining up to the increments on each individual axis. How do I stop this? I want 1 line which accurately represents the correct value on each axis.

Cheers

Stephen

 

[sijpie]

If you double click on an axis or right click and select Properties, you can change the scale on an axis so that it matches and the lines overlap.