freelanceprogrammers.org Forum Index » Visual Basic
how to set axis values in MSChart??
Joined: 15 Apr 2005
Posts: 3
how to set axis values in MSChart??
hello,
i am writing a program in VB6 reads from database (MS Access) integer values and
then plot these values in a Chart using MSChart (Microsoft Chart Control
6.0(OLEDB))
my problem is I want to do
field 1 (1st col) of database table -------->values of x axis in the Chart
row 1 of database table ----------> y axis` values
the rest values of the table ----------> z axis (data of the chart)
but I don`t know what property in MSChart set axis values
any help!
thanks in advance
shayma
Send instant messages to your online friends http://uk.messenger.yahoo.com
[Non-text portions of this message have been removed]
Joined: 15 Apr 2005
Posts: 3
how to set axis values in MSChart??
hello,
thanks for replying
I am using Microsoft Access as database not Excel,
there is no sheets in Access rather tables
from your code (although i havn`t test it yet)
dim mmicode as string
mmicode = Trim(Sheets("MMI").Cells(i, "A").Text)
i don`t see any relation with MSChart?
thanks again
regards
shayma,
--- VBBeginners@yahoogroups.com wrote:
> Date: Mon, 11 Apr 2005 00:46:12 -0700 (PDT)
> From: "m.a mehran" <mehranet@...>
> Subject: Re: how to set axis values in MSChart??
>
>
> hi
> try this
> the name of sheet is MMI and there is a countr i
> form,
> say the first row to say any required row you need
> and
> .text is bring the textr value
> have fun
> Ehsan
>
> dim mmicode as string
> mmicode = Trim(Sheets("MMI").Cells(i, "A").Text)
>
>
> --- shayma sinan <shay_sinan@...> wrote:
> >
> >
> > hello,
> >
> > i am writing a program in VB6 reads from database
> > (MS Access) integer values and then plot these
> > values in a Chart using MSChart (Microsoft Chart
> > Control 6.0(OLEDB))
> >
> > my problem is I want to do
> >
> > field 1 (1st col) of database table
> -------->values
> > of x axis in the Chart
> >
> > row 1 of database table ----------> y axis` values
> >
> > the rest values of the table ----------> z axis
> > (data of the chart)
> >
> > but I don`t know what property in MSChart set axis
> > values
> >
> > any help!
> >
> > thanks in advance
> >
> > shayma
> >
Send instant messages to your online friends http://uk.messenger.yahoo.com
All times are GMT
Page 1 of 1
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Freelace Website Designer - Customer web design and software building.
China Wholesale - Electronics Products
Character Studio - Tutorials and Help
China Wholesale - Electronics Products
Character Studio - Tutorials and Help