View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Bernard Liengme[_2_] Bernard Liengme[_2_] is offline
external usenet poster
 
Posts: 563
Default How to Plot This Data?

Make a Line chart; select the subtype that displays only makers (points)
without lines
Do you want the 12 of Title 1 to be 12 units above the 15, or 12 units above
zero. If the first, chose the 'stacked' subtype
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Catrina" wrote in message
...
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