Excel Forum



Excel Magic Trick # 258: Chart From Noncontiguous Data


When Making Charts, The data series do not have to be next to each other, and they sometimes can even be different sizes.
The axis labels should be to the left or at the top.
To make a chart from noncontiguous data, use the Ctrl key and your Selection Mouse (Or keyboard shortcuts) to highlight data, then make the chart
To Add a data series to a chart, In Excel 2007, highlight data, copy, then click on the chart and Paste.
To Add a data series to a chart, In Excel 2003, highlight data, click on the edge of the data when you see your "move cursor" (white big arrow with four-way pointing thin black arrow)), then drag data series to chart (when you see grey box around chart, let go of mouse.
To copy a chart in Excel 2007, click on chart, Copy, Click in cell, Paste
To copy a chart in Excel 2003, click on chart, hold ctrl, click and drag chart, let go of mouse.
See a Column Chart and a Scatter Diagram.





Got a Question? Ask it Here in the Forum.