We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you two Citrix podcasts. Learn about 2020 trends and get answers to your biggest Citrix questions!Listen Now

x

# Excel chart OLE problem

on
Medium Priority
310 Views
I want to draw a chart by using ole and excel chart, the
data value to be plotted are in a dbgrid
does anyone know how to use these values in dbgrid and
draw a chart...I don't want to go to excel sheet.. but
from dbgrid in Vb to excel chart...........

Comment
Watch Question

## View Solution Only

Commented:
Edited text of question
Commented:
zakman,

here's a sub which takes a column in DBGrid and makes an Excel bar chart of the data

Private Sub MakeBarChart(nDBGridCol As Integer, nExcelCol As Integer)
Dim objXLsheet As Object
Dim objRange As Object
Dim objChart As Object

Dim nPoints As Integer

Form1.MousePointer = vbHourglass

' Create a Worksheet Object:
Set objXLsheet = CreateObject("Excel.Sheet")

' Insert data into an Excel column from a DBGrid's column
nExcelCol = 1
nDBGridCol = 1
With Form1.DBGrid1
.Col = nDBGridCol
Data1.Recordset.MoveFirst
nPoints = 1
While Not Data1.Recordset.EOF
objXLsheet.Cells(nPoints, nExcelCol).Value = CInt(DBGrid1.Text)
Data1.Recordset.MoveNext
nPoints = nPoints + 1
Wend
End With

' Add a ChartObject to the worksheet:
Set objChart = objXLsheet.ChartObjects.Add(100, 100, 200, 200)

' Assign the column created above as a series for the chart:

' Make Excel Visible:
objXLsheet.Application.Visible = True
DoEvents

' Save the Worksheet to disk.
objXLsheet.Parent.SaveAs "C:\XLCHART.XLS"

' Close this instance of Excel:
objXLsheet.Application.Quit
MousePointer = vbArrow
End Sub

Not the solution you were looking for? Getting a personalized solution is easy.

##### Thanks for using Experts Exchange.

• View three pieces of content (articles, solutions, posts, and videos)
• Ask the experts questions (counted toward content limit)
• Customize your dashboard and profile