Need help hiding blank areas in scatter plot Excel 2010
Hello, I have a scatter plot of data that is discontinuous. I only want to show data for the days that our lines are running and minimize the space between days. I need to skip dates on the x axis. How can I do this? I do not want to screenshot parts of the graph and 'stitch' them together. This is a graph that is regularly updated and I don't have time for that kind of solution. I have attached a screenshot of my current graph. I do not want to connect the lines.
Scatter plot data series ordering should move series to the front/back
Right now there does not seem to be a way to change which data series are in the front/back of a scatter plot with multiple data series. Instead, I have to add the data in the order I want it to appear. The up/down arrows in the 'Select Data Source' window should allow one to change the order of appearance of each data series and move them to the front/back of the chart.
