Hey guys, im having some trouble with a bar graph im making for work. I want it to be set up so that it always shows the data for the current week as well as the last 7 previous weeks (so if the data is older than that it doesnt get shown). I thought i could do this with a simple if statement that set the old data, as well as the cells for new data equal to N/A if conditions regarding the weeks position in relationship to the current date were met. It works, but the chart axis still shows these points, just as N/A! So the entire chart just ends up looking like a ton of empty N/A data points with a few bars of data squashed in the middle. Is there any way to get excel to ignore these on the axis so the chart looks normal?
Thanks
Thanks
