D
Dave
I use the insert menu to add a chart - I follow the wizard
to create a XYscatter chart based on a table with two
columns: Time and value
It all looks fine when I click the preview chart during
the wizard steps. But when I open my form, the x-column is
assigned to the first ROW - and all my values get their
own legend.
The x-value should be my first column, and all my data
should be on the same legend.
How do I specify that the x-value is my first column?
I have tried it from VBA: fm![tempplot].PlotOnX = 0 - but
it still only works on the rows - I need to set my data to
be in columns instead...
I have an old form where the chart works the way I want
it - but I cant recall how I did that. I guess I can strip
the form and use the chart in my new form - but I would
rather like to find out how to control it.
to create a XYscatter chart based on a table with two
columns: Time and value
It all looks fine when I click the preview chart during
the wizard steps. But when I open my form, the x-column is
assigned to the first ROW - and all my values get their
own legend.
The x-value should be my first column, and all my data
should be on the same legend.
How do I specify that the x-value is my first column?
I have tried it from VBA: fm![tempplot].PlotOnX = 0 - but
it still only works on the rows - I need to set my data to
be in columns instead...
I have an old form where the chart works the way I want
it - but I cant recall how I did that. I guess I can strip
the form and use the chart in my new form - but I would
rather like to find out how to control it.