Excel Tip: Freeze Chart Size from Cell Adjustments

Excel Tip: Freeze Chart Size from Cell Adjustments

George Mount George Mount

George Mount

Analytics & AI for Modern Excel ?? LinkedIn Learning Instructor ?? Microsoft MVP ?? O'Reilly Author ??

发布日期: 2017年1月10日
+ 关注

As I mentioned in my MyExcelOnline podcast appearance, charting is one of the hardest Excel tools to master. My tip in the podcast showed how to add data with two keystrokes.

Sizing your graph can also be challenging, especially when you add or delete cells. Snap! Stretch! Your graph changes size with cell adjustments.

Follow these steps to avoid this common nuisance:

Continue reading...

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

George Mount的更多文章

  • Free white paper: Five things Excel users should know about Python
    2021年8月2日

    Free white paper: Five things Excel users should know about Python

    If you’ve visited my blog before you’ll know that I see Excel as a valuable slice of the data analytics stack. In fact,…

  • Five Reasons I Wrote Advancing into Analytics
    2021年3月6日

    Five Reasons I Wrote Advancing into Analytics

    The thing that struck me about writing a book is just how much it is like starting a business: you can do your research…

  • The future of analytics may be “low/no-code” … at first
    2021年1月17日

    The future of analytics may be “low/no-code” … at first

    You can’t get through much datascrolling these days without hearing about the rise to dominance of so-called “low- and…

    1 条评论
  • Five myths about learning data analytics
    2020年9月19日

    Five myths about learning data analytics

    I grew to loathe math in school, which culminated in me getting a “D” in one semester of algebra. So it seems nuts that…

    3 条评论
  • Why Excel is the best way to learn data analytics
    2020年8月3日

    Why Excel is the best way to learn data analytics

    The more I advance into analytics, the more I come back to Excel as a teaching and prototyping cool. Yes, of course…

  • Demo guide: The central limit theorem in Excel
    2020年6月7日

    Demo guide: The central limit theorem in Excel

    Excel is not just a powerful tool for doing data, but for learning it: spreadsheets provide an unparalleled opportunity…

    2 条评论
  • What makes a good analytics course?
    2020年5月2日

    What makes a good analytics course?

    I recently had the pleasure of speaking with John David Ariansen of the How to Get an Analytics Job podcast. I…

  • Demo guide: Coin tosses in Excel
    2020年4月20日

    Demo guide: Coin tosses in Excel

    I love teaching data using examples from everyday life. And what’s more quotidian than coins? Plus, the third week of…

  • The law of large numbers, visually demonstrated in?Excel
    2020年4月13日

    The law of large numbers, visually demonstrated in?Excel

    I know very little about gambling. But these very literal “games of probability” make great examples for teaching…

  • Building your data academy: Presentation and slides
    2020年4月7日

    Building your data academy: Presentation and slides

    In September 2019, McKinsey called for the rise of the in-house “analytics academy” to up-skill employees’ data…

社区洞察

其他会员也浏览了