View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Catrina Catrina is offline
external usenet poster
 
Posts: 7
Default How to Plot This Data?

I am working in Excel 2007 and am having a hard time ploting this data.
I have the following titles with associated dollar amounts and need to have
the Titles show up on the X axis with the data showing vertically above each.

I tried a scatter diagram but then it plots each dollar amount as a separate
series. What I want is Title 1 and then $15 and $12 plotted vertically with
same symbol like it would show up horizontally on a line chart.

Title 1 $15.00 $12.00
Title 2 $5.00 $6.00
Title 3 $8.00 $4.00
Title 4 $2.00 $6.00

--
Catrina