Scatter Chart with Multiple X-AXIS

[Daveyk01]

I can do the chart very nicely in Excel, but can not figure out how to do a scatter chart in Access that mimics Excel. In Excel you can have multitple X-AXIS in one chart.

The Y-AXIS is scaled 1 - 100, major divisions of 10.

Each curved line to be drawn on the chart has both Amplitide (Y-AXIS) and Time (X-AXIS) data, with the Time and Amplitude data for each line different.

I wish I could paste and image in to shown an example of what I mean, but I can't. I have attached a JPG example of the Excell Scatter Chart I am trying to mimic.

Thanks kindly for the assistance.

Dave

 

[pavlos]

Using two different charts, one overlapping the other is a quick solution, but not the smartest!

 

[Daveyk01]

Using two different charts, one overlapping the other is a quick solution, but not the smartest!

How did you do that? Can you make the background translucent?

Did you see my example JPG. Can I make that work?

I am trying to figure why it is called a scatter chart in Access since it can only support one line?

 

[pavlos]

Easy, set the first chart as the back one and the other chart to be the front (with transparent back color)

 

[Daveyk01]

Easy, set the first chart as the back one and the other chart to be the front (with transparent back color)

Being able to rotate the chart would be preferable. The columns in an Access Chart Data Sheet are alway Y AXIS, except for the 1st column, which is the X-AXIS data. I can duplicate my chart exactly, laying on its side using a line chart.

It would be great to have an access chart where you had one column of Y AXIS data and the rest of the columns where X-AXIS data.

I guess that doesn't exist.

 

[ChrisO]

Since it’s for a Report you could draw the lines and grid with code in the Detail On Print event.

The Labels could be moved, sized and formatted as required.

Bit of a fiddle but doable.

 

[Daveyk01]

Since it’s for a Report you could draw the lines and grid with code in the Detail On Print event.

The Labels could be moved, sized and formatted as required.

Bit of a fiddle but doable.

I do use quite a bit of code to read the db table and fill in the datasheet associated with the chart.

The problem is there is only one column for and X-AXIS. In Excel, with a scatter chart, each data line has both X-DATA and Y-DATA. See my JPG example again on the top message. Now, I can do the chart very nicely and easily laying on its side as and X/Y chart.

The way I would perfer the chart is vertical, and I may be able to work that out with an X/Y chart. Hmmm........ My blasted ratio compensation formulas go so complicated, for me mathematically, I didn't take the time to fool with the chart more. Now that the math is all worked out, I may take the time to re-visit the chart (currently sideways).

That may work, but not as a scatter chart as I modeled in Excel.

Dave

 

[ChrisO]

In reference to the attached image, what reference numbers do you have for the X/Y values for the three circled points?