close

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;

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()