Is there a way to create a graph in excel made up of four things

[jschill2628]

Is there a way to create a graph in excel made up of four things:
Count
$
Quarter
Region

And have counts on one side, and #$ on the other axis. I cannot seems to get it to work, because when I do the data table below looks dumb, and has blanks in it, and when the data table is correct, the graph does not work.... it won't show the count because the are so insignificant compared to the Thousands of $.

Thanks, I am in the stone age with excel 2003.

 

[SkipVought]

hi,

Change the scale on whichever axis has the smallest values. Usually the scale changes automatically when you assign the secondary axis.

I do not understand your "four things". Please post some sample data from the table that is the source for your chart.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[jschill2628]

Hi,

I tried changing the axis. see the following. I want my chart to look like "chart 2", but I really like the data table on "chart 1". Is the re a way to get the beast of both worlds. Achart from 2 and the data table from 1.

Thanks.

http://s1194.photobucket.com/albums/aa365/jschill2628/

 

[SkipVought]

please post your chart source data (copy 'n' paste from your sheet)

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[jschill2628]

1Q FY11* 2Q FY11* 3Q FY11* 4Q FY11*
Claim Count Expected Total Claim Count Expected Total Claim Count Expected Total Claim Count Expected Total
JD 32 $393,078.88 25 $76,364.80 30 $61,692.28 16 $277,390.22
SK 46 $170,023.69 39 $257,292.44 34 $195,542.10 23 $130,421.23
LN 37 $175,876.87 34 $436,676.89 35 $189,306.53 31 $148,229.76
KM 19 $107,995.33 12 $42,705.12 29 $116,858.53 20 $148,223.86
PM 29 $527,450.87 19 $114,816.14 21 $218,974.86 26 $160,840.90
JR 33 $75,673.66 35 $169,645.84 21 $271,196.36 20 $107,049.33

 

[SkipVought]

I'd recommend Excel Charts by John Walkenbach.

You have Counts & Dollars (2 things) which are Claim Count & Expected Dollars, on the chart that you like.

The data table you want is not possible, with the data you want to display -- apples & oranges.

I'd display the data you posted below the chart you want to see.

On your chart, you might try taking the claim count series and formatting the series with NO GAP. It should display behind the expected dollars series.



Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[SkipVought]

Oh, and my source data looks like this for the chart effect as I just described...
[tt]
QTR AC Claim Count Expected Total Exp Tot $K
1Q FY11* JD 32 393078.88 $393
JR 33 75673.66 $75
KM 19 107995.33 $107
LN 37 175876.87 $175
PM 29 527450.87 $527
SK 46 170023.69 $170
2Q FY11* JD 25 76364.80 $76
JR 35 169645.84 $169
KM 12 42705.12 $42
LN 34 436676.89 $436
PM 19 114816.14 $114
SK 39 257292.44 $257
3Q FY11* JD 30 61692.28 $61
JR 21 271196.36 $271
KM 29 116858.53 $116
LN 35 189306.53 $189
PM 21 218974.86 $218
SK 34 195542.10 $195
4Q FY11* JD 16 277390.22 $277
JR 20 107049.33 $107
KM 20 148223.86 $148
LN 31 148229.76 $148
PM 26 160840.90 $160
SK 23 130421.23 $130
[/tt]
My first few points look like this...
[tt]
|
|xx :::
|xx:::: :::
|xx:::: :::
|xx:::: xx:
|xx:::::::xx:
|xx::::xx:xX:
|xx:xx:xx:xx:
|xx:xx:xX:xx:
+-------------
JD JR KM LN
1Q FY11*
[/tt]

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[jschill2628]

I tried it this way too, but didn't like it. But I THANK YOU for all your help!!

 

[SkipVought]

Thanx. Get the book!

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}