<div>
A sample file would be helpful.<br />
<br />
Also, your range on each worksheet is A2:G10, yet you say that results in one line per worksheet. &nbsp;What range are you actually trying to plot?
</div>


A sample file would be helpful.

Also, your range on each worksheet is A2:G10, yet you say that results in one line per worksheet.  What range are you actually trying to plot?

<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
I have two sheets in a spreadsheet containing data in range A2:G10. How do I generate one graph that has two lines: one for each set of data.
</div>
</div>


Hi

I have two sheets in a spreadsheet containing data in range A2:G10. How do I generate one graph that has two lines: one for each set of data.

Excel: One chart from same range on two sheets

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.