Help with Choosing a graph style

[pooky]

First let me say that I've never had to create a chart in Excel. So I would like to create a chart to keep track of my 401k. I've been keeping a daily track of the current dollar value of my investment versus my total dollar contributions. I would like the left side of my graph to display a solid line for my total dollar contributions and the bottom of the graph to display the date and the marker would be the current dollar value for that date. On my spreadsheet column B displays the current dollar value of my investment and and cell(I3) contains the sum of my total dollar contributions. How can I achieve this graph successfully. In other words I would like to see how my total investment is performing in relation to my contribution. If this is the wrong type of graph to achieve what I am looking for, please let me know. The graph below displays the total dollar contributions but not as a solid line. I really hope this makes sense. Thank You.contibutions.png

[protonLeah]

(How to) Upload a Workbook directly to the Forum
(please do not post pictures or links to worksheets)

• Click Advanced next to Quick Post button at the bottom right of the editor box.
• Scroll down until you see "Manage Attachments",
• Click the "Choose" button at the upper left (upload from your computer).
• Select your file, click "open", click "upload"
• Once the upload is completed the file name will appear below the input boxes in this window.
• Close the Attachment Manager window.
• Click "Submit Reply"

Note: Please do not attach password protected workbooks/worksheets
Ensure to disable any Workbook Open/Autorun macros before attaching!