programaticaly select YY and XX values and Chart

[Daniel Coelho]

Hi,
I have two colums with data and I want to create a chart programaticaly with
those values.
Excel_ChartWizard interprets the two colums as two series, but one of the
colums has my XX values.
How do I do it?
Apreciate all the help.
Regards,

Daniel Coelho

 

[Peter T]

Put a header in the cell above the second column. Include the header cell
above what will become the first series and the empty cell above the first
column (x-values) in the data range. The contents of that header cell will
be used to name the series.

If your columns are not arranged in order x-values, series-1, series-2 etc
there will be a little more work to do.

Regards,
Peter T

 

[Daniel Coelho]

Here's an example:
| Values | |
| 1 | 9:00 |
| 2 | 9:01 |
| 3 | 9:02 |

I used a range A1:B4, the same problem happens, the chart apears weird
because it tries to place them as two series...

I tried to change the header above the first collumm and include that cell
too but the problem remains...

Any more hints?

 

[Peter T]

I guess you missed what I said about the order of x & y values the chart
wizard expects.

Try recording a macro while using the chart wizard to create your chart.
Because you've got Values in the left column, start with only the series
y-values selected, then in the wizard go on to apply the x-values.

The macro will give the basic syntax, all the selects and activates can be
edited out.

Regards,
Peter T

 

[Daniel Coelho]

You were right, I missed what you wrote about the order of x and y.
I placed first the x values and on the chartwizard function I chose columm,
instead of rows, and the chart apeared OK.
The macro option could be a great solution too.
Thanks for your help and time.
Regards,

Daniel Coelho