MSChart - how to adjust the y-axis manually?

[Lysandra]

my problem is that I want to compare two different bar charts (on the same form). Therefore I need to have equal scale of the y-axis. The biggest bar should not be 100% of the hight of the chart. e.g. when I have 4 as my biggest y-value, but the theoretical maximum is 5, the bar should only extend to 80% and not to 100%.
Is there any way to set the minimum and maximun value for the y-axis? I didn't find any example so far.

thanks!

[leopardhunting]

If we are talking about the same thing, try this:
Right click over the y-axis, choose format axis. A window should open with tab choices. Choose scale. It has the min and max as well as the major and minor units.

let me know if that helped.

[Kinmon]

Yo, Lysandra. Are you familiar with MSChart? Cause i'm using mschart too and i'm new using this. Do you know if i can overlap (super impose) the graph? I want to compare my chart that's on the same form and on the same chart. For example, plot a chart first with the data sent to the computer and then send another pack of data to the computer and update the chart. Do you think MSChart can do that?

Or anyone?

[Lysandra]

Thanks leopardhunting!
That helped. I always forget to check the object itself for more properties by right-clicking on it.

[Lysandra]

Hey Kinmon,
My data is based on a Access database. Using the "Set" command you can update your chart. I put it on a command-button. In my case it looks like this:

Private Sub Command1_Click()
Dim dbChart As Connection
Set dbChart = dbcls.dbName
Set rsChart= New Recordset

rsChart.Open "select SummeV2 from Module", dbChart,_
adOpenStatic, adLockOptimistic

With MSChart1
Set .DataSource = rsChart
.ShowLegend = True
End With
End Sub

dbcls is the class which I use to open my database-connection.

I'm fairly new to MSChart too, but hope this helps.

[Kinmon]

Hi Lysandra, thanks for posting the code. But can you explain how the code works, if possible. Like, ....as connection, rschart (is that your chart name?), rschart.Open.....(what's this command? does it call a database, cause i don't use database. I use matrix to store my data collected).

[Kinmon]

please help. anyone?

[mnad]

Lysandra use a recordset that extract datas from a database.
So if you don't use a databse you cannot use this code.

instead, Try to set the Chartdata property = your matrix

If the first series of a multi-dimensional array contains strings, those strings will become the labels of the chart