How to add a MTD graph in my dashboard that is made up of daily data ; help!!

[Ascribne]

Could anyone help me incorporate a MTD graph in my dashboard? I only receive Daily Data and am unsure how I can add a MTD graph. Thanks

[AliGW]

Welcome to the forum.

I am sorry - I really have no idea what you are asking for help with. Several people have viewed your workbook and you have no help yet, so it's safe to say that you need to give much more detail.

[Ascribne]

Sure! i can try to explain more. I appreciate the comment.

I am putting together a call center dashboard. I have all daily data. I cant figure out a way to make a Month-to-Date call stat graph. I tried using SUM but I couldnt differentiate the months.

The attached workbook is a sample of daily data and a graph I currently use that shows daily data. Anyone that could provide information on how to use formulas to get MTD information would be much aprpeciated.

Thanks!!

[josephteh]

If I understand you correctly, what you want to show is a MTD column in your existing column chart. PivotCharts unfortunately do not allow for Total to show in chart.

One way to work around is add [Total Row] in your data table, then select the ranges (cover 1 empty cell below the [Total Row] you want to plot chart.

How to add a MTD graph in my dashboard that is made up of daily data.png