Please see attached table.
I am attempting to show performance of three wireless antennae against a frequency range. The range starts at 5740 and end at 5830.
I need to be able to demonstrate via a graph, the performance of SNR-SU, dish60, m-wave 2f, mwave 2f – ring against the various frequencies.
PLEASE HELP. confused Motswana
Re: Chart
What's your actual question?
Can't you just plot each series with the frequency as the X-axis?
Re: Chart
Hi, thanks for speedy reply, cannot plot the chart. I need to display each of the antennae’s performance against each other with the given range of freq. almost displayed as line charts layered over each other
Re: Chart
So why can't you do that?
Re: Chart
been trying to do that, not winning!!!!!!!.
Re: Chart
See the attached.
Is that the sort of thing you want?
Re: Chart
getting there, the issue is that at each freq, the x axis is not showing correct scale. i.e. at 5740, the x axis should show 25 for snr, 27 disk 60, 21 for m-wave 2f, 22 m-wave2f ring. Where is it getting the range on the x from 0 - 160. Also the y series needs to increase in 5's not 10's. The X range needs to be between 15 - 50. aaaaarrrrrgggggghhhhh
Re: Chart
Try changing Axis for each series to Secondary Axis.
To do that right click each serie, select Format Data series... and goto the Axis tab.
Re: Chart
inktec
use another chart type. The basic line chart will be what you desire. The chart type you used is a line chart, but stacked. No secondary axis issues are involved.
Wigi
Re: Chart
Wigi
Well spotted, I was wondering what was going on with the OP's chart.
Re: Chart
I found it in the beginning strange, too. I thought that first line was multiplied by 1, the second by 2, the third by 3, the fourth by 4. (ooh these strange thoughts...) As the values plotted are similar to each other, this is almost the same as stacking. Then I saw what was going on.
Don’t have an account yet? Register yourself now and be a part of our community!
