Building chart trouble

[gr]

Hi, I'm developing an application with Access and I have
been stopped because I need some data to be send to Excel
and make a chart.I just can't figure out how to do it. I
already tried Access newsgroup with no luck.

I'm sending to Excel data that corresponds to some
measurements done in some equipment.
Problem 1. I don't know how many measurements I will get.
Problem 2. I don't know the number of equipments that will
be tested.

I'll show you an example, until know what I'm getting in
Excel looks like this:

PRODUCT READING VALUE REMARKS
Ball Mill 1 Stator current ixR [A] 2 415.000
Ball Mill 1 Stator current ixS [A] 0.000
Ball Mill 1 Stator current ixT [T] 0.000
Ball Mill 1 Motor voltage [V] 0.000
Ball Mill 1 Excitation current Ixe [Adc] 403.00
Ball Mill 1 Excitation voltage Uxe [Vdc] 322.00
Ball Mill 1 Speed setpoint nw [rpm] 13.300
Ball Mill 1 Speed actual nx [rpm] 13.400
Ball Mill 1 Motor power (calc.) [kW] 7 616.000
Slightly overloaded
Ball Mill 1 Line Voltage [Vac] 4 143.000
Ball Mill 1 Airgap x [mm] 0.000
Ball Mill 1 Airgap y [mm] 0.000
Ball Mill 2 Stator current ixR [A] 2 325.000
Too High
Ball Mill 2 Stator current ixS [A] 0.000 Not
available on the VMS
Ball Mill 2 Excitation current Ixe [Adc] 402.00
Ball Mill 2 Excitation voltage Uxe [Vdc] 333.00
Ball Mill 2 Speed setpoint nw [rpm] 13.500
Ball Mill 2 Speed actual nx [rpm] 13.500
Ball Mill 2 Motor power (calc.) [kW] 7 604.000
Slightly overloaded
Ball Mill 2 Line Voltage [Vac] 4 181.000

So, the equipment is Ball Mill x, where I can have from 1
to N ball Mills, but also other equipment (the field is
open to the user). Then the next column is the measurement
but not all measurements are done to all equipment, the
next column the value and finally remarks.

How can I code in Access in order to build the chart where
the series must be the name of each equipment?? and where
a measurement is not done for certain equipment then plot
0 or leave a blank space??

Thx in advance, if I'm not clear enough please let me
know. If you want to see the Excel worksheet that until
know I have (build from Access) to see how I'm getting the
data please tell me so I can send it.

thx again,
gr

 

[Earl Kiosterud]

gr,

I'm not sure how you want the data charted. A chart in Excel works in one
of two ways. 1) You have categories (which appear equally spaced on the X
axis, and have a label, like Ball Mill. The categories are usually in a
column. Then you have an associated set of values, which determine the
height of the columns, etc., in the chart. There can be additional sets of
values (series). Or 2) You have no categories, but instead two sets of
values, X and Y, in two columns, which determine where points are plotted
against the X and Y axis of the charts. Yours sounds like the first case.

In your case, if the series are to be different for each equipment, you'll
need to get them into different columns. But then what are the categories?
Or is the entire chart for Ball Mill, and the series for 1, 2, etc.

Perhaps you can hand-make a representative chart in Excel, based on your
actual data, and then go from there.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

Hi, I'm developing an application with Access and I have
been stopped because I need some data to be send to Excel
and make a chart.I just can't figure out how to do it. I
already tried Access newsgroup with no luck.

I'm sending to Excel data that corresponds to some
measurements done in some equipment.
Problem 1. I don't know how many measurements I will get.
Problem 2. I don't know the number of equipments that will
be tested.

I'll show you an example, until know what I'm getting in
Excel looks like this:

PRODUCT READING VALUE REMARKS
Ball Mill 1 Stator current ixR [A] 2 415.000
Ball Mill 1 Stator current ixS [A] 0.000
Ball Mill 1 Stator current ixT [T] 0.000
Ball Mill 1 Motor voltage [V] 0.000
Ball Mill 1 Excitation current Ixe [Adc] 403.00
Ball Mill 1 Excitation voltage Uxe [Vdc] 322.00
Ball Mill 1 Speed setpoint nw [rpm] 13.300
Ball Mill 1 Speed actual nx [rpm] 13.400
Ball Mill 1 Motor power (calc.) [kW] 7 616.000
Slightly overloaded
Ball Mill 1 Line Voltage [Vac] 4 143.000
Ball Mill 1 Airgap x [mm] 0.000
Ball Mill 1 Airgap y [mm] 0.000
Ball Mill 2 Stator current ixR [A] 2 325.000
Too High
Ball Mill 2 Stator current ixS [A] 0.000 Not
available on the VMS
Ball Mill 2 Excitation current Ixe [Adc] 402.00
Ball Mill 2 Excitation voltage Uxe [Vdc] 333.00
Ball Mill 2 Speed setpoint nw [rpm] 13.500
Ball Mill 2 Speed actual nx [rpm] 13.500
Ball Mill 2 Motor power (calc.) [kW] 7 604.000
Slightly overloaded
Ball Mill 2 Line Voltage [Vac] 4 181.000

So, the equipment is Ball Mill x, where I can have from 1
to N ball Mills, but also other equipment (the field is
open to the user). Then the next column is the measurement
but not all measurements are done to all equipment, the
next column the value and finally remarks.

How can I code in Access in order to build the chart where
the series must be the name of each equipment?? and where
a measurement is not done for certain equipment then plot
0 or leave a blank space??

Thx in advance, if I'm not clear enough please let me
know. If you want to see the Excel worksheet that until
know I have (build from Access) to see how I'm getting the
data please tell me so I can send it.

thx again,
gr

 

[Guest]

I need for example:

5 ¦
4 ¦ + +
3 ¦ * + ' +
2 ¦ * ' + ' +
1 ¦___*_'_+_¦_*__'___+___¦.......¦......¦

M1 ¦ M2 ¦

Where: * = Equipment 1, '= Equipment 2 ... + Equipment 3
And

M1 = Measurement 1, M2 = Measurement2, etc.

My problem is how to arrange the data by code in order to
plot in this way. also having present that I dont know how
many equpiment and/or measurements will get from Access.
thx

 

[Earl Kiosterud]

GR,

OK, I think you need to concatenate your first two columns, so you get a
single item, like
"Ball Mill 1 Stator current ixR." That can be done with something like
=A2 & A3
That will give you the column for your categories (which you'll probably
have to align vertically, because they'll be long).

Then you just need an associated column with the values, and you're ready to
chart it.

So if
Product, which I think is "Ball Mill 1", is in column A, and
Reading, which I think is "Stator current ixR [A]", is in column B, and
Value is in column C, you might have this in column F and G

In G2:
=A2 & " " & A2 ("Ball Mill 1 Stator current ixR [A]")

In F2
=C2 (mirrors the value in C2).

Copy them down (with the fill handle), and chart with these two columns.
--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

I need for example:

5 ¦
4 ¦ + +
3 ¦ * + ' +
2 ¦ * ' + ' +
1 ¦___*_'_+_¦_*__'___+___¦.......¦......¦

M1 ¦ M2 ¦

Where: * = Equipment 1, '= Equipment 2 ... + Equipment 3
And

M1 = Measurement 1, M2 = Measurement2, etc.

My problem is how to arrange the data by code in order to
plot in this way. also having present that I dont know how
many equpiment and/or measurements will get from Access.
thx