Hello Guys,

I've been inputting values that spans multiple columns and rows to create a graph.
Take for an example, i had value on A1:A9 and results would be spanning across  B1:D9.

I would like to create a graph that has A1:A9 displaying on the x axis. While Results on B1:D9 to be analyzed and output to one specific bar on the graph.
Let's say at x axis representing dates while y axis representing car plates moving on the same road.
On 20th january we had 3 cars passing by and input into the grid. The same car plate that were commonly passing by the given area will be reflected on the graph at how many times it appeared. 

I tried to look everywhere for my answer. However, i fear that this might requires and a simple graph will not be able to work out to what i wanted.

Need some advise here.
Thankyou.

Could you please specify, which elements should be on the x-axis? Once you said "A1:A9", but also "dates on the x-axis".

What's on the y-axis? The number of unique cars that have passed that certain day?

In my eyes, the issue is not the graph (Excel is capable of that), but more the structure you want to have. I guess, you have to do some data rearrangements in order to get the designated result.