How to modify the position in which one column of an Excel chart is positioned above another?

  Kiến thức lập trình

I hope they are fine!
I must deliver a report for my company and they ask me to change the “plane” in which the columns are displayed. That is, according to the screenshot of the graph that I share with you, the navy (dark blue) column is the one that should “stand out” and be positioned ahead of the gray column:

enter image description here

Even though I tried to change the order of the data, the second column always presents a “higher hierarchy” over the first column. That is, the order in which the data is consulted does not matter. As an example in the following screenshot I will modify the order by placing the WEB VISIT 2024 data first, but as we see, now the WEB VISIT 2023 column is the one that takes the relevance:

enter image description here

That is why when modifying the column overlap value, the right column usually “steps on” the left column.

enter image description here

It doesn’t matter if the data for the graph comes from different sheets for each year, or if the same table stores the data for both 2023 and 2024 together. The problem is generated from the graph.
I have already studied the option of using another type of graph, however, I wanted to consult with people who are experts on the subject or request help to find out if it is a mistake on my part. I thank you in advance for your support.
I will be very attentive to your comments and ready to carry out tests.
Excel Version: (Microsoft® Excel® para Microsoft 365 MSO (versión 2403 compilación 16.0.17425.20176) de 64 bits)
Greetings,

I want the navy column to have a higher hierarchy and be ahead of the gray column.

Not like it is now where the gray column is the one that rests in front of the navy column

enter image description here

New contributor

Félix Terán Gorrín is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

LEAVE A COMMENT