Presentation Solutions
  • Products
    • Create Documentation
    • Compare Documentation
    • Repair Documentation
    • Video Tutorials
    • FAQs
  • Corporate Identity
    • Create with Preference Manager
    • Create with Customised Content
    • Corporate Identity Design Services
  • Charting
    • Charting
    • Link to Excel source data
  • Buy Now
  • Our Clients
  • Client Login
  • FAQs

CAGR line not displaying

adminNo commentsFebruary 13, 2019

This is because a new setting has been introduced in Excel 2016 which is applied by default to new charts created by Create or native office.

How to fix
• Right click on chart.
• Click “Select Data”.
• Click the “Hidden and Empty Cells” button.
• Uncheck the “Show #N/A as an empty cell” checkbox.
• Click the “OK” button.

You must be logged in to post a comment.

Quick links

About us

FAQs

Video Tutorials for Create

Design services

Careers

Client Login

Software Terms and Conditions

Cookie Policy

Privacy Statement

United Kingdom

Chapter House
33 London Road
Reigate
Surrey
RH2 9HZ

+44 333 939 0100

info@presentationsolutions.co.uk

support@presentationsolutions.co.uk

United States

155 North Wacker Drive
Suite 4250
Chicago
IL 60606

+1 312 283 8505

info@presentationsolutions.co.uk

support@presentationsolutions.co.uk
Copyright © 2018 Presentation Solutions Limited. All rights reserved. Microsoft, PowerPoint, Excel, Word and the Office logo are trademarks or registered trademarks of the Microsoft Corporation in the United States and/or other countries. All other trademarks and registered trademarks are properties of their respective owners.