Hi,

I am using Excel 2013. Currently, I have to make a chart, that is not a problem in itself. It's the data series that is difficult:

The chart is supposed to show all the data for the current month - but only up to today.


Excel is not the tool I'm generally working with at the moment. I have been working with Excel a lot in my previous jobs,
but now I'm into QlikView and not so fast anymore in Excel. I don't know exactly how to tweak a chart once I have
created it. There seem to be only a limited number of options available, and dynamically limiting the x-axis is not among
them if I haven't overlooked it.
What I can do of course is just use a series of the dates in the current month in one row and then use and the letters
of the respective column below that and then use an HLOOKUP in some cell to display what column has today's date.
=> I guess I have to somehow include a reference to that cell in the definition of the data_series to use for that chart,
but how to do that?
(I can of course construct the statement denoting the necessary range (like >> $C$47:$H$47 <<) in another cell, but then just clicking on that cell
for the dimension_range of that chart does not seem to do the trick)

Perhaps look at http://peltiertech.com/Excel/Charts/...umnChart1.html

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Tushar Mehta also has some nice charts.
See attached for some possibilities

@ pecoflyer Reg "Je suis Charlie"
Moi aussie

Attached Files

Tushar Mehta Dynamic Names And Charts.xlsm (34.9 KB, 8 views)

Okay, thank you all!

I have made it. I simply introduced a number denoting the month of the date into the source list and using this I constructed a COUNTIFS() statement.
It works now.

Best regards,

Officer_Bierschnitt