Hey guys,
I've been trying to figure this out for a while but I can't seem to plot a line graph without Excel including the cells that are either blank or labelled "#N/A". Since my goal with this was to make the chart dynamic and changing constantly over time, I wanted to allow the graph to only include the numbers plotted and nothing more (including the extra dates).
I've included a sample of what I'm working on right now. What I wanted to see was the graph at the bottom starting from 12/30/2005, not the 1998 date that I've specified earlier in the chart.
Thanks for all the help provided!
Bookmarks