Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
How to Plot This Data?
Hi Catrina.
I have just put up a chart for you at:- www.pierrefondes.com It is item number 43 towards the top of my home page. There are 2 graphs in my file. I think that you want the one in the foreground but am not sure. I must admit I am not clear of your requirement but hope the file I have put up for you is what you want. If it isnt maybe you could explain further in terms of the chart that I have put up so that we can help you out a bit more. Please hit Yes if my comments have helped. Thanks. "Catrina" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Removing Plot lines between plot points on a line chart | Charts and Charting in Excel | |||
show 3 sets of data per data point in a scatter plot | Charts and Charting in Excel | |||
How do I plot two columns of data as one data point/marker in a ch | Charts and Charting in Excel | |||
Can I copy x-y scatter plot data direct from one plot to another? | Charts and Charting in Excel | |||
Can you show data in a data table but not plot it on the chart? | Charts and Charting in Excel |