extract data series from a chart

sdtex

New Member
Joined
Sep 12, 2006
Messages
2
Is there a way to extract the data series used to create a chart assuming one doesn't have the original data series that created it?

Thanks
 

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.

venkat1926

Well-known Member
Joined
Aug 21, 2005
Messages
4,824
try this.you may succeed

activate(click) the chart
highlight the formula bar
hit F9
you will have the data bothe for x and y values.

do some preliminary expriments.

\venkat
 

sdtex

New Member
Joined
Sep 12, 2006
Messages
2
it is created by excel....but I'm also wondering if it were made in word or powerpoint if it could be pasted into excel and the data extracted
 

PaddyD

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
"it is created by excel"

Way it's created not the only issue - what is it now? for example, if someone copied an excel chart as a picture into word, it's not a chart any more, it's a picture, so no data. Have you tried the suggestion from venkat?

"but I'm also wondering if it were made in word or powerpoint if it could be pasted into excel and the data extracted"

Not that I'm aware of.

if you need more, please post back with the specifics of what you've got, not generic descriptions of the problem.
 

Jon Peltier

MrExcel MVP
Joined
May 14, 2003
Messages
4,966
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
If it's a regular Excel chart, you can extract the data from a chart even if you don't have the worksheet it was linked to:

Macro to Extract Data from a Chart
http://support.microsoft.com/default.aspx?scid=kb;en-us;137016

(use the Excel 97 version of the code).

In principlle, if it's an MSGraph chart made in PowerPoint or Word, you can still extract the data. Double click on the chart, switch to the datasheet, copy the data from the grid, and paste it into Excel.
 

Forum statistics

Threads
1,136,272
Messages
5,674,749
Members
419,525
Latest member
helensesc

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
Top