Basic Chart

[Paul Ilacqua]

I'm fairly new to Charting and I have data like this.. I want to show the
line's BTS by week. The Chart wizard does not give me what I need... Please
help if possible.. I'd like a line chart


Line Week BTS

6600 1 86.67%
6810 1 58.00%
7610 1 88.80%
8600 1 95.43%
8610 1 90.42%
8620 1 90.08%
8650 1 55.84%
8660 1 91.85%
8670 1 96.41%
8690 1 89.00%
6600 2 88.29%
6810 2 83.75%
7610 2 81.81%
8600 2 89.81%
8610 2 70.87%
8620 2 115.11%
8630 2 69.66%
8650 2 81.02%
8660 2 75.56%
8670 2 100.65%
8690 2 101.04%
6600 3 84.20%
6810 3 95.00%
7610 3 88.80%
8600 3 95.17%
8610 3 81.46%
8620 3 103.73%
8630 3 88.62%
8650 3 87.56%
8660 3 77.03%
8670 3 73.55%
8690 3 79.17%
6600 4 89.47%
6810 4 60.00%
7610 4 77.12%
8600 4 81.78%
8610 4 78.01%
8620 4 77.94%
8630 4 40.10%
8650 4 91.51%
8660 4 87.69%
8670 4 100.47%
8690 4 103.67%
6600 5 81.04%
6810 5 87.00%
7610 5 79.77%
8600 5 73.88%
8610 5 82.18%
8620 5 95.84%
8630 5 90.31%
8650 5 98.25%
8660 5 81.77%
8670 5 77.93%
8690 5 86.50%
6600 6 96.27%
6810 6 24.00%
7610 6 68.83%
8600 6 99.57%
8610 6 88.25%
8620 6 85.00%
8630 6 65.69%
8650 6 81.99%
8660 6 61.91%
8670 6 88.00%
8690 6 86.50%

 

[Del Cotter]

I'm fairly new to Charting and I have data like this.. I want to show the
line's BTS by week. The Chart wizard does not give me what I need... Please
help if possible.. I'd like a line chart

Line Week BTS

6600 1 86.67%
6810 1 58.00%
7610 1 88.80%

Eliminate the gap between the header and the data, like so:

Line Week BTS
6600 1 86.67%
6810 1 58.00%
7610 1 88.80%

Then, with the cursor cell placed somewhere in the data range, start the
Pivot Chart wizard, and follow the instructions.

 

[Paul Ilacqua]

Del,
I put the space in there for clarity on this post.... I'm leaning toward
having a group for each distinct line and creating a new data series for
each. I'm honing in on a horizontal bar chart. I appreciate your help.

 

[Del Cotter]

I'm leaning toward having a group for each distinct line and creating a
new data series for each. I'm honing in on a horizontal bar chart. I
appreciate your help.

I think you're going the right way. My pivot charts (or pivot table then
chart wizard, for those like me at home who lack a version of Excel more
recent than 97) was just a quick way of doing what you say, creating a
column or row for each line. Doing the same thing by hand is also
feasible, so that instead of:

Line Week BTS
6600 1 86.67%
6810 1 58.00%
6600 2 88.29%
6810 2 83.75%

You have

1 2
6600 1 86.67% 88.29%
6810 1 58.00% 83.75%