I will be happy to set up the chart for you and show you how it works. Would you like to send me your file or shall I send you a sample file
Ok, go to www.wikisend.com and upload the file there (no need to sign up). You will then get a page that has the download link and File ID. Copy the download link or the File ID and come back here and paste it in your reply.
Where is the download link, or file ID?
Perhaps I should create a sample file, what do say?
Here is a sample of what you should send me
Ok, here you go
Please check it and let me know if it needs any adjustments before sending you the instructions
Ok, one moment please...
Ok here are the instructions
- Select the data in A1:B5- Click Insert from the Ribbon then click the Line button, then choose the first Line icon- Right click on one of the bars on the graph and choose Select Data- Select Series1 from the window on the left, then click the Remove button on top- Select Series2 from the window on the right, then under the Horizontal Categories (on the right) click the Edit button- In the Axis label range field select or type =Sheet1!$A$1:$A$5- Click OK, and again OK
Hope this is ok Please feel free to reply if you need further clarification or click Accept if this answers your question fully.
Ok hold on I will prepare the instructions for that. In the meantime thank you for clicking the accept button if you the graph is ok
Ok, select the data A1:B5
Click Insert > Chart
Select Line, then select the first line icon.
Let me know when done
Ok, now click the Next button, then click the Series tab on top. You will see two series listed. Remove Series2
hmm.. Here is a screenshot for the Mac version
Let's try this
If you see the Finish button you can click at this point, and then we will modify the chart
In other words when you have the chart drawn with 1, 2, 3 in the x-axis let me know
Thanks. Will be happy to help you again
But just in case you want to know how it is done (I assume at this point that you have Excel 2008)
Just plot the chart the you way you did first (when you had 1, 2, 3 in x-axis) then click on the line graph to select it. Then Press CTRL Click and choose Select Data. From this point you can continue with my first instructions, i.e
- Select Series1 from the window on the left, then click the Remove button on top- Select Series2 from the window on the right, then under the Horizontal Categories (on the right) click the Edit button- In the Axis label range field select or type =Sheet1!$A$1:$A$5
- Click OK, and again OK
Sure. Here are the step by step instructions for uploading files
Ok, do you need both lines on the same graph or each on a separate graph
Ok. here you go
Let me know if it needs any tweaking
You're welcome. Glad to help