Extract data from a chartin excel

nfir33

New Member
Joined
Dec 10, 2020
Messages
3
Office Version
  1. 365
Platform
  1. Windows
Hi
Is it possible to extract data from a chart I made in excel last year? Chart below
I'd like to add data to it rather than start all over again
Any help would be appreciated.
Please also note, that I am not a technical whizz, so will need step by step instructions
Thanks in advance

1607603915908.png
 

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"
Hi there, thanks for replying so quickly.
I don't have the original data that I used. To do this, I'd have to go back through all the sales data and put it back into a table before plotting.
I was hoping there was a way of retrieving that data from the chart
Is that possible?
 
Upvote 0
Hey, I double clicked on the chart and then chose extract data in excel and it brought up the data.
Turns out I had been more organised than I thought and did have the old data
Thanks for the help.
Appreciated
 
Upvote 0
Solution

Forum statistics

Threads
1,214,788
Messages
6,121,588
Members
449,039
Latest member
Arbind kumar

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top