I have created a chart in Excel using a pivot table. The chart I am using is
2 axes, bar and line and I am using 3 sets of data. One of which I want as a
bar and the other 2 as lines. It defaults to the other way around ie 2 bars
and one line. The data I wish to switch to a line is so small that I can't
click on it and change to secondary axix. is there another way to do it?