Bonbon ede nou delivre sèvis nou yo. Lè l sèvi avèk sèvis nou yo, ou dakò pou nou sèvi ak bonbon.
Ide: Lòt lang yo se Google-tradui. Ou ka vizite a English vèsyon nan lyen sa a.
Ouvri yon sesyon
x
or
x
x
enskri
x

or

Kouman ekstrè done ki soti nan tablo oswa graf nan Excel?

doc-ekstrè-tablo-done-1
Nan Excel, anjeneral nou sèvi ak tablo pou montre done ak tandans pou pi byen gade, men nan pafwa, petèt tablo a se yon kopi epi ou pa gen done orijinal yo nan tablo a kòm anba a Ekran yo montre. Nan ka sa a, ou ka vle ekstrè done ki nan tablo sa a. Koulye a, Tutorial sa a ap pale sou done èkstraksyon soti nan yon tablo oswa graf.
Ekstè done ki soti nan tablo ak VBA

Navigasyon -AutoText (ajoute anjeneral itilize tablo AutoText pane.then yon sèl klike sou insert li lè ou bezwen.)

Excel ajoute nan zouti pou mete tablo kaskad nenpòt lè

flèch ble jarèt dwat Ekstè done ki soti nan tablo ak VBA


1. Ou bezwen kreye yon nouvo fichye ak chanje non li kòm TabloData. Al gade nan Ekran:

Kutools pou Excel, ak plis pase 120 sou la men fonksyon Excel, amelyore efikasite k ap travay ak sove tan travay.

doc-ekstrè-tablo-done-5

2. Lè sa a, chwazi tablo a ou vle ekstrè done ki sòti nan ak laprès Alt + F11 kle ansanm, ak yon Microsoft Visual Basic pou aplikasyon pou fenèt pops.

3. Klike sou Antre > Modil, Lè sa a, kole anba a VBA postal eklate la Modil fenèt.

VBA: Ekstè done ki soti nan tablo.

Sub GetChartValues()
	'Updateby20150203
	Dim xNum As Integer
	Dim xSeries As Object
	xCount = 2
	xNum   = UBound(Application.ActiveChart.SeriesCollection(1).Values)
	Application.Worksheets("ChartData").Cells(1, 1) = "X Values"
	With Application.Worksheets("ChartData")
		.Range(.Cells(2, 1), _
		.Cells(xNum + 1, 1)) = _
		Application.Transpose(ActiveChart.SeriesCollection(1).XValues)
	End With
	For Each xSeries In Application.ActiveChart.SeriesCollection
		Application.Worksheets("ChartData").Cells(1, xCount) = xSeries.Name
		With Application.Worksheets("ChartData")
			.Range(.Cells(2, xCount), _
			.Cells(xNum + 1, xCount)) = _
			Application.WorksheetFunction.Transpose(xSeries.Values)
		End With
		xCount = xCount + 1
	Next
End Sub

4. Lè sa a, klike sou kouri bouton nan kouri VBA la. Al gade nan Ekran:

doc-ekstrè-tablo-done-2

Lè sa a, ou ka wè done yo extrait TabloData fèy.

doc-ekstrè-tablo-done-3

Ranje ekspòtasyon kòm grafik

Kutools' Ranje ekspòtasyon kòm grafik se vize pou konsève oswa ekspòtasyon yon selil seleksyon kòm fòma plizyè grafik.
Dokiman ekspozisyon doc kòm foto

Ide:

1. Ou ka fòma selil yo menm jan ou bezwen.

doc-ekstrè-tablo-done-4

2. Done yo nan tablo a chwazi se ekstrè nan selil an premye nan tablo a ChartData nan default.

peye atansyon1Si ou enterese nan sa a addi-an, download 60-jou gratis jijman an.


Rekòmande Zouti Productivity

Biwo Tab

lò star1 Pote onglè sou lamen pou Excel ak lòt biwo lojisyèl, jis tankou Chrome, Firefox ak nouvo Internet Explorer.

Kutools pou Excel

lò star1 Etonan! Ogmante pwodiktivite ou nan minit 5. Pa bezwen okenn ladrès espesyal, sove de zè de tan chak jou!

lò star1 300 karakteristik nouvo pou Excel, fè Excel anpil fasil ak pwisan:

  • Rantre selilè / ranje / Kolòn san yo pa pèdi done.
  • Konbine ak Konsolide Pliye Plizyè ak Manyèl.
  • Konpare Range, Kopi plizyè chif, Konvèti tèks nan dat, inite ak konvèsyon lajan.
  • Konte pa Koulè, Paging subtotals, Avanse Triye ak Super Filter,
  • Plis Chwazi / Insert / Efase / Tèks / Fòma / Link / Kòmantè / Workbooks / Worksheets Zouti ...

Piki ekran nan Kutools pou Excel

Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
  • To post as a guest, your comment is unpublished.
    Astro · 1 years ago
    This doesn't appear to work for a scatter plot as it only extracts one set of "x" data. How can I amend it to extract all "x" data sets?
    • To post as a guest, your comment is unpublished.
      Sunny · 1 years ago
      Sorry I did not found the solution about that.
      • To post as a guest, your comment is unpublished.
        Carlos · 1 years ago
        i've tried with a scatter plot graph as well, but only get one line of valor.


        i need so much to find a way to extract data from scatterplot graphs.
  • To post as a guest, your comment is unpublished.
    Ian · 1 years ago
    I failed to get the prices of a fund chart on my mac excel 2011 . Run time error '91' object variable or block variable not set . Don't know how to debug . Appreciate any help .
  • To post as a guest, your comment is unpublished.
    jignesh · 1 years ago
    Very useful and perfect
  • To post as a guest, your comment is unpublished.
    Berk · 1 years ago
    gives me values that i created chart with not all the values in range
  • To post as a guest, your comment is unpublished.
    Leo · 2 years ago
    Amazing command, thanks a lot!

    I used it with a pivot chart and it works!