Chart for showing with text type data and number data

[afshin]

I want to prepare a chart with showing a trend of displacement(x-y chart type ,red and cyan in below chart) and geology material limitation in depth(upper sand ,clay Till, claystone).but I don't know how do it? Which chart type is proper for geology material limitation in depth? or is other way to showing geology material limitation and displacement trend simultaneously,similar below chart in access?

[June7]

How did you produce that image? We use Gint software to generate bore hole graphs. I briefly looked into replicating in Access and found it far too challenging. Don't know what you mean by 'material limitation'.

[afshin]

that image is output of a software with name of :GTilt.
material limitation is the geology name of soil or rock in depth.
for that chart i can to create three fields with name,Depth,Displacement and material by data types of number,number and text type respectively.
but i don't know how create similar that chart in access?

[June7]

This might not be possible in Access. Or at least beyond my programming capabilities. Review https://www.accessforums.net/program...vba-29178.html

Not a geologist, don't know what you mean by 'displacement'.

If you can graph these data separately in multiple Access charts, charts can be overlaid, with the upper charts set with transparent background. Turn axis lines on or off as appropriate for each chart.

[afshin]

Displacement is variable data for X-Axis.that is deflection of borehole toward Vertical in every depth.
I know what you say.I had previously thought to that.
I should prepare two graph(GR1 and GR2 in below)but i don't know how prepare GR1?and if i can prepare that,how prepare that scale's compatible with GR2?

[June7]

You can do GR-2? GR-1 looks somewhat like a stacked bar chart. Did you review the link I referenced and download the db? I don't quite remember what I did in that db but it might give you some ideas.

[afshin]

I try to use your ideas.I prepare GR-2 similar this:

,but for using of your idea i need to chart with this showing:

can you help me about this.
data source of my Chart is here:

[June7]

Thread is marked solved - is it?

An image of your navigation pane does not provide data nor help me analyze. I would have to work with data.

[afshin]

Yes, my problem is resolved by your 'stacked bar chart' idea.
but for better using of your idea,i need to answering to my question in ago thread.
my source data is here.

[June7]

Best I could do is change the query to:

TRANSFORM Avg(Table1.installevel) AS AvgOfinstallevel
SELECT Table1.DDispA
FROM Table1
GROUP BY Table1.DDispA
PIVOT Table1.Readdate;

And adjust the axis scales as needed. As well as text alignment for the scale labels.

[afshin]

Result of your query doesn't produce my favorite chart.
Your suggested chart isn’t rotation of my chart that is other chart. Because "GROUP BY Table1.DDispA". not "GROUP BY Table1. installevel"