Cuidiú fianáin linn ár seirbhísí a sheachadadh. Trí úsáid a bhaint ár gcuid seirbhísí, aontaíonn tú úsáid a bhainimid as fianáin.
Leid: Aistrítear Google-theangacha eile. Is féidir leat cuairt a thabhairt ar an English leagan den nasc seo.
Logáil isteach
x
or
x
x
Cláraigh
x

or

Conas sonraí a bhaint as cairt nó graf i Excel?

doc-extract-chart-data-1
In Excel, is gnách go n-úsáideann muid an chairt chun sonraí agus treocht a thaispeáint le breathnú níos soiléire, ach uaireanta, b'fhéidir gurb é an chairt cóip agus níl sonraí bunaidh na cairte mar a thaispeántar thíos. Sa chás seo, b'fhéidir gur mhaith leat na sonraí a bhaint as an gcairt seo. Anois tá an teagasc seo ag caint faoi shonraí a bhaineann as cairt nó graf.
Faigh sonraí ó chairt le VBA

Nascleanúint -AutoText (cuir cairteacha a úsáidtear de ghnáth go AutoText pane.then cliceáil amháin chun é a chur isteach nuair is gá duit.)

cuir feabhas ar uirlisí chun cairt eas a chur isteach ag am ar bith

mboilgeog ceart gorm arrow Faigh sonraí ó chairt le VBA


1. Ní mór duit bileog oibre nua a chruthú agus é a athainmniú ChartData. Féach ar an scáileán:

Kutools le haghaidh Excel, le níos mó ná 120 feidhmeanna Excel handy, Feabhas a chur ar éifeachtúlacht oibre agus sábháil am oibre.

doc-extract-chart-data-5

2. Ansin roghnaigh an chairt gur mhaith leat sonraí a bhaint as agus brúigh Alt + F11 eochracha ag an am céanna, agus Microsoft Visual Basic d'Iarratais pops fuinneog.

3. cliceáil Ionsáigh > Modúil, ansin déan an cód VBA a ghreamú go dtí an popping Modúil fhuinneog.

VBA: Sliocht sonraí ó chairt.

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. Ansin cliceáil Rith cnaipe chun an VBA a reáchtáil. Féach ar an scáileán:

doc-extract-chart-data-2

Ansin, is féidir leat a fheiceáil go mbaintear amach na sonraí ChartData bileog.

doc-extract-chart-data-3

Raon Easpórtála mar Grafach

Kutools' Raon Easpórtála mar Grafach Tá sé mar aidhm cealla roghnúcháin a shábháil nó a onnmhairiú mar bhformáidí grafacha ilghnéitheacha.
réimse onnmhairithe doc mar phictiúr

Leid:

1. Is féidir leat na cealla a fhormáid de réir mar is gá duit.

doc-extract-chart-data-4

2. Baintear sonraí na cairte roghnaithe go dtí an chéad chill den bhileog ChartData mar réamhshocraithe.

aird a thabhairt 1Má tá suim agat sa bhreis seo, an triail saor in aisce 60-lá a íoslódáil.


Uirlisí Táirgiúlachta Molta

Tab Office

óir star1 Tabs tabs láimhe le Excel agus bogearraí eile Oifige, cosúil le Chrome, Firefox agus Internet Explorer nua.

Kutools le haghaidh Excel

óir star1 Iontach! Méadú do tháirgiúlacht i 5 nóiméad. Ní gá aon scileanna speisialta a bheith agat, ach dhá uair an chloig a shábháil gach lá!

óir star1 Gnéithe Nua 300 le haghaidh Excel, Déan Excel Mór Éasca agus Cumhachtach:

  • Cumaisc Cill / Sraitheanna / Colúin gan Sonraí a Chailliúint.
  • Ilchláir agus Leabhair Oibre a Chomhcheangal agus a Chomhdhlúthú.
  • Déan comparáid idir Ranganna, Cóipeáil Ilchéimeanna, Tiontaigh Téacs go dtí Dáta, Aonad agus Comhshó Airgeadra.
  • Count by Colors, Subtotals Paging, Ard-Shórtáil agus Scagaire Super,
  • Tuilleadh Roghnaigh / Ionsáigh / Scrios / Téacs / Formáid / Nasc / Comment / Leabhair Oibre / Bileoga Oibre Uirlisí ...

Lámhach scáileán de Kutools do 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!