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 ...
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.