Forum Discussion
Data in area chart not matching the source
Looking to see if anyone has any answers for my issue below.
I am trying to track manpower for group A and B. In my table below, Group A is showing that their work will be completed in June. Group B is showing that their work will be starting in July.
In my bar chart below, I am using it to visualize the data in the table above. The data shows that both groups are starting and completing in the correct months based off the data.
In my area chart below, using the same data, I am using an area chart (which is preferred) to visualize this information. But the graph shows Group A completing in July and Group B staring in June. It shows that the work will be overlapping, which is not true.
I am hoping that someone is able to help me figure out how to make the area chart correctly show the information from the table above instead of showing the workload overlapping.
3 Replies
What you use is stacked area chart. I.e. it shows one of top of another. Try to use another one
most left here.
Hi Sergei,
Thank you for your suggestion. When I try that option, it still shows both work overlapping which unfortunately is not true from the data.
That's how Area works. For Group A value goes from 1843 in June to zero in July and we have this line. For Group B it shows from zero in June to 597 in July. Thus overlapping. However, if you instead of zero will keep empty cells, right click on chart, Select Data, when
and here
we have desired result. Alternative you may use =NA() if data is generated by formulae, and in setting Show #N/A as empty cells plus Gaps for empty cells.
