Excel 2003 - chart with text categories in X and frequencies in Y

Hello! I'm sure this is a simple question, please bear with me, and point me
to an older answer if it's been done before :)

It's Excel 2003. I have 2 columns of data:

A list of category names I want to make into my X axis (including the
categories with values of zero)

and

A corresponding column of integers which I want to be my Y values (they are
frequencies of the words/concepts in the X category column, resulting from a
content analysis, if you're interested!).

How do I make the graph? I keep getting charts that miss of many of the
category names, including some with non-zero Y values.
.

Relevant Pages

  • Re: Dates in Excel 2007 graph axis dialogs - thanks
    ... always consistent and line charts won't work. ... Jon Peltier, Microsoft Excel MVP ... Line Chart: X as Time-Scale Axis ...
    (microsoft.public.excel.charting)
  • Re: Need help with SeriesCollection Object Please !
    ... Well Peter your explanation of my questions make sense and are sound answers. ... You seem very experienced with Excel and VBA:) ... Function GetSourceSheet(sFmla As String, sWSname, sFile As String) As ... ran my code on certain other charts sometimes it would return ...
    (microsoft.public.excel.programming)
  • RE: Exporting to Excel to specific name range
    ... What I want to do is to use the same data source for the criteria data ... datasource to an outside source - My customer wants the data to be ... I want to be able to use the same charts for both criteria data ... You can export data to Excel from Access without a problem. ...
    (microsoft.public.access.externaldata)
  • Re: finding a file in excel
    ... I have no doubt the Chart bug, whatever it was, was a problem for you, ... I agree Charts were significantly ... I don't quite follow the bug you mentioned with ranges in Excel 97 but not ... For the toolbar thing, I was just going by what my experience had been. ...
    (microsoft.public.excel.programming)
  • Re: Charting software: what does The Economist use?
    ... business charts, multidimensional charts, ... Excel with "workarounds" is fine for business charts. ... R is developed and supported by thousands of statisticians worldwide. ... You can get the R base system and all packages free from the Comprehensive R ...
    (microsoft.public.excel.charting)