I should have read a few more posts before I asked. Looks like the answer I
will need (I have not read it yet) is he
peltiertech.com/Excel/ChartsH...iffSheets.html
quot;Ezlpoquot; wrote:
gt; I am trying to make a chart (line graph) that uses data from many different
gt; worksheets.
gt;
gt; The graph is being created to plot sales data week to week for many
gt; different salespeople. Each week is its own worksheet.
gt;
gt; There are around 70 sales people, but for the report I am only interested in
gt; 8-25 (but potentially all 70). Their names are listed in column A, but
gt; because there are so many of them they are not always in the same row as they
gt; were the week (read: worksheet) prior.
gt;
gt; Now I know I can take the time to create a graph for each salesperson, but I
gt; was hoping there would be an easier solution. I do not have crystal reports
gt; (not that I would know how to use them) and I don't have any skill using the
gt; Virtual Basic features (although I fear that for this I will need to learn
gt; some).
gt;
gt; Thank you in advance.
gt;
gt;
- Oct 18 Sat 2008 20:47
Making a chart using data from different worksheets in a workbook.
close
全站熱搜
留言列表
發表留言