Chart Data Table formats not working

Adrian Miric Adrian Miric

Adrian Miric

Owner, AuditExcel.co.za & Excel-Skills-Assessment.com

发布日期: 2020年5月5日
+ 关注

If you like Pivot Tables, you will also be using Pivot Charts and, because they add information, you may also use the Data Table feature which shows the actual numbers below the chart. The problem relates to the Data Table number formats not working. If you try and custom format the numbers it ignores it and if you have numbers in millions it seems to only differentiate the first thousand.

For more on how to fix this watch the video.

要查看或添加评论，请登录

Adrian Miric的更多文章

  • Excel Automation with Power Query Course - 02 December 2021
    2021年11月18日

    Excel Automation with Power Query Course - 02 December 2021

    If you spend hours getting data and then cleaning it up (every month) then this course is for you. It will teach you…

  • Spell Check Excel Documents
    2021年8月17日

    Spell Check Excel Documents

    You can spell check Excel documents but there are a couple of tips and tricks you need to use to make it act more like…

  • Start Of Month Formula in Excel
    2021年7月27日

    Start Of Month Formula in Excel

    Surprisingly, there is no start of month formula in Excel. There is an end of month formula (EOMONTH) but no formula…

  • Stop Users From Inserting/ Deleting Rows - 2 Ways
    2021年7月15日

    Stop Users From Inserting/ Deleting Rows - 2 Ways

    A common requirement is how to stop Excel users from inserting or deleting rows. Typically a template is set up and the…

  • IF Function Not Working With Numbers
    2021年7月7日

    IF Function Not Working With Numbers

    Your IF function not working with numbers? A recent question from a client, it is important to understand what a number…

  • Improve Dashboards with Stock Images
    2021年6月29日

    Improve Dashboards with Stock Images

    With a recent addition in Excel , it is now possible to access and include stock images into your Excel spreadsheet…

  • Sum All Negative Numbers
    2021年6月1日

    Sum All Negative Numbers

    If you need to sum all the negative numbers in Excel, a good function to know is the SUMIFS function. It has multiple…

  • Average Excluding Outliers in Excel
    2021年5月18日

    Average Excluding Outliers in Excel

    Your average not making sense? Perhaps you need to average excluding outliers in MS Excel to get a more realistic…

  • Change the name of items in a Pivot
    2021年5月11日

    Change the name of items in a Pivot

    Do you need to change the name of items directly in the Pivot Table? When working in Pivot Tables you sometimes get…

  • Add Happy Face Emoji
    2021年5月4日

    Add Happy Face Emoji

    If you want to, you can add the happy face emoji into Excel. There is an easy way to do it 2 simple steps.

社区洞察

其他会员也浏览了