I have a set of data regarding my recent Bitcoin investment and I'd like to plot growth on a chart.

Unfortunately, with the way the data is laid out on my spreadsheet, I can't seem to get the chart to make any sense.

What I'm looking for is a chart similar to what I've got, but where the line in the chart represents the Growth Percentage values.

Excel Screenshot

What's the concept that I'm missing behind the layout or selection of the data for the chart?

  • How are you creating the chart? The data works fine for me. – Raystafarian Jan 7 '16 at 15:29
  • I've tried a number of ways. Highlighted A5-B7, click Insert>Chart>Line Chart – Ortund Jan 7 '16 at 15:38
  • Are your dates in date format? – Raystafarian Jan 7 '16 at 15:42
  • 2
    Seems it was the graph I was using (100% stacked line) which was wrong. – Ortund Jan 7 '16 at 16:18
  • 1
    Can you post your solution as an answer to help others in the future? – Burgi Jan 7 '16 at 16:44

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Browse other questions tagged or ask your own question.