Showing multiple items in a graph

[someonerandom]

Hi,

I have a geology database that i want to show what percentage of metals are in a hole, however id also like to display the lithology type on the y axis as well. Im trying to build this (excuse the poor artist rendition) The coloured bars are the Lithology (rock type) and the percentages are the metal percentages. i cant find a way to combine that data and graph it. Im not set on a bar graph, as long as the data is visually displayed well im ok (i.e not datatable as i can do that 🙂 )

The data is sorted like so

And like so

Im just not having any luck,

could someone help? ive got the correct datatypes etc i just cant build the graph?

[V-pazhen-msft · Accepted solution]

@someonerandom 

You may create a simple chart like below.

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@someonerandom , At first look, seem like a stacked visual with Hole on the x-axis and Lith Type as the legend and metal % as the value

[someonerandom]

Cheers it seems to want to count the Y axis, id like to have it show 0-70 or whatever the final depth is instead it just counts..

[someonerandom]

Anyone able to help with this one? i just want to show metre for metre on the Y axis and show what lithology type is there and it percentage?> can this be done>?