Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community
SOLVED

Excel, formating of chart

Copper Contributor

Hi, I have a chart for an proses I am developing. It contains serval sections that consists of steps. I what to make a column chart where the three sections are built up by the consisting steps.

The purpose of the chart is to et an overview of hove many units are at each step and the total in each section, but I can’t get the formation to be as I want it, Se image

Img 1.PNG

 

The probmels are in the tabel under the chart. As of now, all data is on the last two rows, and there are som extra nots for the first section. 
This is how i whant to have it...

IMG 2.jpg

 How do i make it?

4 Replies
best response confirmed by Vikber (Copper Contributor)
Solution

@Vikber 

I don't think you can do that with the data table of a chart.

Instead, create a range of cells below the chart with the layout that you want.

If I understand ou correct, to have the chart and table as two seperat entetys?

@Vikber 

Yes, that is correct.

@Vikber be careful with stacked bar charts. Not having a common baseline can lead to faulty comparisons. 

1 best response

Accepted Solutions
best response confirmed by Vikber (Copper Contributor)
Solution

@Vikber 

I don't think you can do that with the data table of a chart.

Instead, create a range of cells below the chart with the layout that you want.

View solution in original post