???? ?? Excel ??? ???? ????? ?? ??????? ?? ??? ??????

???? ?????? ???? ??????
???? ID: 300643 - ?? ???????? ?? ?????? ??? ?? ?? ???? ???? ???? ??.
???? Microsoft Excel 2000 ??????? ?? ??? ?? ???? ??, ?????213814.
???? Microsoft Excel 98 ?? ?? ???? ?? ?????? ???????, ?? ??? ?????137016.
??? ?? ??????? ???? | ??? ?? ??????? ????

?? ????? ??

??????

Microsoft Excel ???, ?? ?? ???? ??? ???? ?? ??????? ?? ????? ??? ????? ?????????? ?? ????????????? ??? ?? ???? ??? ?? ???? ????? ?? ?? ????? ??? ??, ?? ???? ?? ???, ??? ??? ??????????? ?? ?? ?? ?? ???????? ?? ?? ???? ???? ????? ?? ???? ?? ?? ????????? ??? ?????? ??? ???? ????? ?? ????? ???? ?? ???? ??, ?? ???? ?? ???? ??? ??? ?? ??????? ??? ?? ?????, ????? ?? ????????? ?????? ?? ??? ?? Microsoft Visual Basic ?? ????? ?????

???? ???????

Microsoft ???????????? ?????? ???? ???????? ?? ??? ??? ???? ??, ???? ??? ??? ?? ?????? ?? ?????????? ??? ??? ?????? ???? ?? ????.. ?????? ???????? ?????? ?? ???? ????? ???????? ?? ??? ???????? ????? ??? ?? ???? ?? ????? ???? ???.. ?? ??? ????? ?? ?? ?? ????? ?? ?? ??? ???????????? ???? ?? ?? ??????? ?? ?????? ??? ????? ????? ???????????? ?? ????? ?? ???? ???? ?? ??? ???? ?? ??? ??.. Microsoft ?????? ???????? ?? ????? ????????? ?? ???????????? ?? ?????? ??? ?????? ?? ???? ???, ??, ?? ?? ???????? ?? ???? ??????? ?????????? ?? ?????? ???? ?? ??? ???????? ??????????????? ?? ?????? ?? ???????????? ????? ?? ??? ??????? ???? ??????..

?????????? ????? ?????? ??? ?? ?????????? ?????? ????????????? ??? "ChartData" ???? ????? ????? ???? ???? ???? ????? ?? ????? ?????? ??? ???? ?????
  1. ??????? ????? ??? ????? ?????? ??? ???? ????:
    Sub GetChartValues()
       Dim NumberOfRows As Integer
       Dim X As Object
       Counter = 2
    
       ' Calculate the number of rows of data.
       NumberOfRows = UBound(ActiveChart.SeriesCollection(1).Values)
    
       Worksheets("ChartData").Cells(1, 1) = "X Values"
    
       ' Write x-axis values to worksheet.
       With Worksheets("ChartData")
          .Range(.Cells(2, 1), _
          .Cells(NumberOfRows + 1, 1)) = _
          Application.Transpose(ActiveChart.SeriesCollection(1).XValues)
       End With
    
       ' Loop through all series in the chart and write their values to
       ' the worksheet.
       For Each X In ActiveChart.SeriesCollection
          Worksheets("ChartData").Cells(1, Counter) = X.Name
    
          With Worksheets("ChartData")
             .Range(.Cells(2, Counter), _
             .Cells(NumberOfRows + 1, Counter)) = _
             Application.Transpose(X.Values)
          End With
    
          Counter = Counter + 1
       Next
    
    End Sub
    					
  2. ???? ????????????? ??? ?? ?? ?????????? ???????? ????, ?? ??? ???? (???? ?????? ?????) "ChartData" ???? ?? ??? ?? ??? ??????
  3. ?????? ?? ?? ?????????? ???? ????? ?? ??????? ?? ??? ????? ?? ??? ?????

    ???:: ???? ?????????? ?? ?? ???? ??? ????? ????? ?? ????? ???????? ?? ?? ?? ?? ???? ????
  4. ?????GetChartValues???????

    ????? ?? ???? ?? "ChartData" ?????????? ??? ????? ???

???????????? ???? ?? ??? ????? ???? ???? ?? ??? ???

????? ?? ?????? ???????????? ???? ?? ??? ???? ?? ???? ??, ?? ??? ?? ????? ?? ?? ???? ????? ?? ??? ???? ???? ???????? ?? ??????????? ????????????? ?? ???? ???? ?? ??? ?????? ???
  1. ????? ?? ??? ????, ?? ???????? ?? ??????????? ????????????? ??? ????? ??? ?? ?? ????? ???? ???? ??? ?? ?? ?????? ?? ??? ???? ???????? ?? ????? ????? ????? ?? ??? ????? ????? ??? ???????? ????? ??? ????? ???? ???

    ???:: ????? ?? ??? ????????????? ???, ???? "[Book1]" ???? ?????? ??? ?????? ??, ?? ?? ???? ???? ?? ???? ?? ?? ?????? ???? ????? ???? "!" (apostrophe ?? ?????? ???? ????? ?? "'!") ?? ???? ???? ?????? ?? ?????? ?? ????? ???? ??? ????? ?? ??? ??? ???? ?????? ?? ?????? ?? ??? ???? ???? ????? ??? "]" ?? ?????? ???? ????? (?? apostrophe ?? ?????? ???? ?????)? ???? ???? ?? apostrophe ??? ?????? ???? ????? ?? ????? ???? ?? apostrophe ???? ????? ?? ??? ??? ????? ???? ???? ?? ???? ????????
  2. ???? ?? ????? ?? ??? ???-????? ????ChartData.
  3. ??????? ??? ?? "ChartData" ?? ??? 1 ?? ??? ????? ??? ???? ???? ?? ENTER ?????? ?? ??? ?? ??? ??? ??????????? ?? ???????? ????????????? ?? ????? ?? ??? ???? ???? ??????
  4. ??? ???? ?? ????? ????? ?? ???? ????? ?? ??? ????? ???? ??, ?? ????? ???????
  5. Excel 2003 ?? Excel 2002, ??? ????? ??????????????? ??????????????, ?? ???? ???????? ?? ????????? ????.

    ??? Excel 2007, ????? ????????:??? ??,?????? ??????? ?????????Connenctions????, ?? ???? ???????? ?? ????????? ????.
  6. ?????????? ????????? ???, ???? ?? ????????? ???? ?? ??? ?? ??? ????, ?? ???? ???????? ?? ????????? ????.
  7. ????????? ?? ????????? ????????? ????? ???, ???????????? ???? ?? ????? ?? ??? ?? ????? ?? ??? ????, ?? ???? ??? ????? ????OK.
  8. ??? ???? ????? ?????? ????? ??????? ???? ??
    Your formula contains an invalid external reference to a worksheet.
    it is likely that the sheet name that you typed in step 3 is not the same as the original. Go back to step 1.
  9. TheSource Filebox may now be blank. This indicates that all links point to the active file rather than the missing or damaged file. ????? ????,??? ????.
The chart now references and interacts with the recovered data on the renamed sheet in the active workbook.
Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.

???

???? ID: 300643 - ????? ???????: 04 ?????? 2010 - ??????: 2.0
???? ???? ???? ??:
  • Microsoft Office Excel 2007
  • Microsoft Excel 2002 Standard Edition
??????: 
kbdtacode kbhowto kbprogramming kbmt KB300643 KbMthi
???? ?????? ????????
??????????: ?? ???? ?? ???? ??????? ?? ????? ?? Microsoft ????-?????? ?????????? ?????? ?????? ???? ??? ??. Microsoft ???? ??? ????-???????? ?? ????-???????? ????? ?????? ?? ???? ???????? ???? ?? ???? ????? ????? ??? ?? ??? ?????? ?? ???? ???? ???? ??? ????? ??. ???????, ????-???????? ???? ????? ???? ???? ???? ???. ?????, ????????, ?????-???? ?? ??????? ?? ???????? ?? ???? ???, ???? ?? ??? ?????? ???? ???? ??? ????? ??? ?? ???? ??. Microsoft ??????? ??? ???? ?? ?????? ?? ??????????, ????????? ?? ??? ?????? ?? ???? ????? ?? ???? ???????? ?? ??? ???? ????? ?? ??? ????????? ???? ??. Microsoft ????-?????? ?????????? ?? ????? ?????? ?? ?? ??? ??.
?????????? ?? ??????? ????????? ??????? ??:300643

??????????? ???

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com