Excel draw stacked chart with empty future data

Q&A_ExcelChart_Q001

Solution to draw Excel stacked chart with empty future data

First of all, it is true that Excel stacked chart would consider empty data as “0” instead of ignoring them like the case in non-stacked chart, it is the behavior that cannot be changed.

In order not to change data range every week, it is better to set dynamic data range so that if there is no data in December 19, the data range (both data and x-axis label) is resized to December 12.

You can find the solution in the below article

Excel graph change data range dynamically

Outbound References

http://www.contextures.com/xlNames01.html

 

 

Wyman W
Wyman is a Business Analyst based in Hong Kong, specialized in business analysis, project management, and also creating custom Function and Sub solutions, and is proficient in report automation with Access.

He is also a:
- Microsoft Most Valuable Professional (Excel)
- Microsoft Community Contributor
- Microsoft Office Specialist in Access / Excel
- Microsoft Specialist in MS Project
- Microsoft Technical Associate
- Microsoft Certified Professional
- IBM SPSS Specialist

Leave a Reply

Your email address will not be published. Required fields are marked *