Get Digital Help
  • Home
  • Functions
  • Charts
  • Formulas
  • Products
  • Archive
  • Contact
  • About Me
    • About me
    • Blogs I read

    How to create

    Column chart

    Stacked column chart

    100% stacked column chart

    Bar chart

    Line chart

    Area chart

    Pie chart

    Doughnut chart

    Scatter chart

    Bubble chart

    Waterfall chart

    Stock chart

    Radar chart

    Map chart

    Treemap chart

    Sunburst chart

    Histogram chart

    Combo charts

    Column and Line chart

    Chart basics

    Group chart categories

    Four ways to resize a chart

    Customize chart axis

    Align chart with cell grid

    Excel chart components

    Highlight

    Column in stacked column chart

    Group of chart bars

    Line in line chart

    Highlight a column in a stacked column chart

    Highlight a bar in a chart

    Animate

    Line chart

    Bar chart

    Column chart

    Advanced charts

    Label line chart series

    Position month and year between chart tick marks

    Graph a Normal Distribution

    Graph an equation

    Add horizontal line to chart

    Primary data is hidden behind secondary data

    Color chart bars by value

    Improve your X Y Scatter Chart with custom data labels

    Use pictures in a column chart

    Build a comparison chart

    Add pictures to a chart axis

    Quickly change chart data source

    Format fill color on a column chart based on cell color

    Use drop down lists to compare data series in an excel chart

    Hierarchical relationships in an excel chart

    Interactive candlestick chart

    Heat map using pictures

    Use a map in an Excel chart

    Custom data labels in a chart

    Dynamic data labels in a chart

    Analyze trends using pivot tables

    Hide specific columns [VBA]

    Change bar color in charts [VBA]

    Dynamic chart – Display values from a table row or column

    Use a mouse hovering technique to create an interactive chart

    Interactive Excel chart [VBA]

    Select a cell in a table and the chart updates automatically [VBA]

    Advanced Gantt Chart Template

    Excel charts: Multiple series and named ranges

    Change chart data range using a Drop Down List [VBA]

    Dynamic Gantt charts

    Use dynamic ranges to automatically add new values

    Create a dynamic chart




Advanced Gantt Chart Template

This Gantt chart template is a stacked bar chart and new tasks are added as you type them. Completed (green) […]

Dynamic Gantt charts

Today I am going to show you how to create a dynamic Gantt chart in excel 2007. A Gantt chart helps […]

      Formula categories

      Count Dates Extract Index and Match Logic Lookups String manipulation Sum Time Vlookup
  • Welcome! I am Oscar and here to help you!

    Feel free to comment and ask Excel questions.

    Don´t forget to add my RSS feed and subscribe to new blog articles by email.

  • Free Blog Emails

  • Search website