sorting and charting some values..

[soundengineer]

so I would like to make a Wireless Frequency Chart...
basically I have values in the hundreds with 3 decimals...(example being 525.625).
and I'm trying to make a chart to show those frequencies at a given milliwatt strength(example being 10mW)
I want to be able to enter the frequencies(multiple..like 6-12 of them) and then have them show up on the graph/chart at their given strengths..
would like to have a skinny bar graph type look..spikes sticking up with x-axis being frequency and y-axis being mWatts.

what happens is I am going to do some complex math on a secon page to calculate intermodulation frequencies and then I will plot those as well..teh importance of the y-axis is that thise intermod frequencies will happen at half strength and quarter strength... this graph will be useful to me so that when I have 8 or 10 wireless frequencies going on all at the same time that I can figure out values that will work together without interfering with each other too much(example being that 519.000 and 520.000 create intermod 519.500 so I cant use that frequency)

attatched is the page of what I have as data to design my graph with....
and a basic picture to show what I want it to look like..

everything I try...nothing gets close..so I figure I'm doing something wrong

[MSP77079]

Hi sound,

Excel does not do what you want very well.

First thing, select the data and create a standard bar chart. Then, go to Chart >> Source data, and in the Series tab, copy what is shown for values of the Frequency series and paste them in the empty box at the bottom for category (x) labels. Then, delete the Frrequency series. Close the source data dialog.

Next, go to Chart >> Chart Options. In the Axes tab, change the Category (x) axis to Time-scale. This will look very weird for a moment. Close the chart options dialog.

Either double-click or right-click on the x-axis and open the Format axis dialog. In the Number tab, change the format from Date to Number.

To get the spikey look, double-click or right-click on one of the bars and open the Format Data Series dialog. In the Options tab, increase the Gap Width to suit your pleasure.

Hope this helps.

[soundengineer]

thanks...that was actually pretty easy once you showed me that...

is there a way to make it not graph #DIV/0! so that it doesnt try to make 0 my lowest when I have a #DIV/0! box?