![]() |
|
#6
|
||||
|
||||
|
The following works fine for me. Note that I changed the position of the .Chart.Refresh line, but that's only to get the chart data to refresh correctly.
Code:
Sub Demo()
Dim iShp As InlineShape, wb As Object, ws As Object
With ActiveDocument
Set iShp = .InlineShapes.AddChart(Type:=xlRadarMarkers, Range:=.Range.Characters.Last)
With iShp
Set wb = .Chart.ChartData.Workbook
wb.Application.ScreenUpdating = False
Set ws = wb.Worksheets(1)
With ws
.Range("A2:A7").NumberFormat = "General"
.Range("A2").Value = 1
.Range("A3").Value = 2
.Range("A4").Value = 3
.Range("A5").Value = 4
.Range("A6").Value = 5
.Range("A7").Value = 6
.Range("B1").Value = "Item 1"
.Range("B2").Value = 100
.Range("B3").Value = 120
.Range("B4").Value = 140
.Range("B5").Value = 160
.Range("B6").Value = 180
.Range("B7").Value = 200
.Range("C1").Value = "Item 2"
.Range("C2").Value = 210
.Range("C3").Value = 190
.Range("C4").Value = 170
.Range("C5").Value = 150
.Range("C6").Value = 130
.Range("C7").Value = 110
End With
.Chart.Refresh
wb.Application.Quit
End With
End With
End Sub
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How do you paste a graph from Excel into Word as picture without line appearing? | swygant | Word | 10 | 07-01-2014 03:23 PM |
| Custom Line Graph x, y1, y2 | bendi | Excel | 2 | 06-26-2014 07:07 AM |
column clustered bar graph with a line graph as secondary axis
|
Alaska1 | Excel | 2 | 06-09-2014 07:13 PM |
| Priority of line graph vs bar graph in terms of front to back positioning on a chart | DavePPointuser | PowerPoint | 1 | 04-30-2014 10:57 AM |
| Line Graph Overlay | mgonda | Office | 0 | 11-14-2011 05:53 PM |