• Products
    • Sage Intelligence Reporting
      • Enrolment
    • Velixo
      • Enrolment
        • Velixo for Acumatica
        • Velixo for Sage Intacct
  • Services
    • Consulting
    • Training
    • Development
  • Support
    • Support Overview
    • Create Support Ticket
    • Book A Session
    • Knowledgebase
  • About
    • About Us
  • Contact
  • Products
    • Sage Intelligence Reporting
      • Enrolment
    • Velixo
      • Enrolment
        • Velixo for Acumatica
        • Velixo for Sage Intacct
  • Services
    • Consulting
    • Training
    • Development
  • Support
    • Support Overview
    • Create Support Ticket
    • Book A Session
    • Knowledgebase
  • About
    • About Us
  • Contact
Quick Support
Book Demo

How to stop your Excel charts from disappearing

By admin on May 17, 2019

Have you ever experienced your Excel charts disappearing when you hide the columns showing the data? By default, Microsoft® Excel® shows only visible data in a chart. In this tip, we will show you how to easily overcome this problem, by following these simple steps:

1. First, lets create a simple chart with your data to demonstrate.
 

 
2. If you had to hide columns A and B, your chart will disappear. To prevent this from happening, click anywhere on the chart and from the ribbon, select Chart Tools > Design > Select Data
 

 
3. In the “Select Data Source” dialogue box, select “Hidden and Empty Cells” in the bottom left hand corner.
 

 
4. In the “Hidden and Empty Cell Settings” dialog box, check the box “Show data in hidden rows and columns”.
 

 
5. Select “OK” twice.
 
Now, go ahead and hide your data. Your chart should still display with the hidden data!

The post How to stop your Excel charts from disappearing appeared first on Sage Intelligence.

Source: Excel on Steroids

Post navigation

Part 1: Take a quick tour through Sage 50cloud Intelligence
Part 2 of 3: Learn how to customize your reports with Sage 50 Intelligence Reporting

Leave a Reply Cancel reply

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

Recent Posts

  • Why Working In Excel Works
  • Alchemex Welcomes Velixo 6 For MYOB Advanced
  • Welcome to Velixo Reports Version 4.2
  • Part 3 of 3: Learn how to create a Management Pack in Sage 50cloud Intelligence
  • Part 3 of 3: Create and customize reports easily with the Financial Report Designer

Search

Contact Us

Phone: +61 2 9890 2339
Email: sales@alchemex.com.au
Address: PO Box 212, Deaken West, Canberra, Australia, 2600

Products

  • Intelligence Reporting
  • Velixo Reports

Services

  • Consulting
  • Training
  • Development

About

  • About Us
  • Partners
  • Blog

Support

  • New Ticket
  • Community (Coming Soon)
  • Knowledgebase

Phone: +61 2 9890 2339
Sales: sales@alchemex.com.au
Support: support@alchemex.com.au

Facebook-f Linkedin

© All rights reserved Alchemex Pty Ltd 2020

Made with ❤ by Unfazed Ltd