I have a table in Excel, 'Tab_Visitas' which has the hits for the month.
CgOnY.png
What I wanted to do was make a line chart, but only with the selected date and prior to the selected date, type this:
VwPCY.jpg
Obtaining dates already have:
DataSelecionada:= DATE($Q$2;MATCH($P$2;Tab_Meses;0);1)
DataAnterior:= EDATE(DataSelecionada;-1)
How do I put the chart only display the data of that month and the previous one?
Bookmarks