Chart with left and right axes. X-axis is timebased

M

Marcel

H
I would like to show SPEED and DISTANCE based on TIMESTAMP in a chart
so i need three axis
Left: Spee
Right: DISTANC
Bottom: TIM

I tried with chChartTypeScatterLine but I could nor create a right axis
I tried with chChartTypeLine but formating of the x.axis failed:
cht.Axes(c.chAxisPositionBottom).NumberFormat = "mm/dd/yyyy" or = '"Medium Time" => Message: Invalid Parameter
(but .NumberFormat = '"Medium Time" worked with chChartTypeScatterLine !!

What chart type do I have to choose and what about time formatiing. The Timestamp is comming from SQL-DB

Thanks for Hel
Marcel
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

OWC10: How to add secondary axis for different data type into the original chart with OWC10? 4
Reversing Dates Sequence along X axis in a chart 3
Multi Axis Pivot Chart 12
sideways stacked bar charts with line series on the same axis 0
Dynamically Scale X Axis on Column Chart Based on Number of Catego 1
Scaling issue with Date/Time format 2
Chart data scrunches to left when adding X axis date series 0
how to switch the primary and secondary Y axis to opposite chart s 2

Top