Excel 2013 - Combo Chart: Min-Max Range for One Field is Large

[beadedbytes]

I've been trying to create a Combo chart (bars and line) in Excel 2013 with both Primary and Secondary axes. Sample data is provided below with a pipe delimiter for parsing. (FYI ... 'Return%' field is actually displayed as a percent (e.g. 1st entry below of 0.04819 is actually shown as 4.9%.)

My dilemma is this. For the 'Qty_Sent' field, the values range from less than 10M up to 4MM. Given this broad range, it makes the the other 2 fields on the really small on the graph.

I've even divided the 'Qty_Sent' by 1000 in order to make the items on the graph. For example, 4003101 became 4003.101. Unfortunately, the items are still relatively small.

Any other suggestions on how to solve this dilemma? Thanks in advance for feedback.

Item#|Qty_Sent|Return%|Cost_Rate
Item A|9690|0.04819|40
Item B|36002|0.02367|105
Item C|113033|0.00835|198
Item D|125895|0.00976|238
Item E|127299|0.00882|255
Item F|275286|0.00963|263
Item G|102271|0.00991|267
Item H|115920|0.00793|285
Item I|71995|0.0094|289
Item J|127280|0.00921|289
Item K|64511|0.00862|295
Item L|227960|0.0095|301
Item M|96241|0.00941|302
Item O|4003101|0.00926|311
Item P|102341|0.00979|327
Item Q|102253|0.00871|329
Item R|300571|0.00837|342
Item S|64123|0.00828|384
Item T|123824|0.00918|428
Item U|74895|0.00566|476
Item V|11386|0.00755|506
Item W|237580|0.00724|987

 

[SkipVought]

Hi,

Use a PRIMARY and a SECONDARY Value Axis.

You can do this by selecting the Series you want on the Secondary Value Axis, and assign the Axis to Secondary.

I'm doing this from memory, as I'm not at my PC, so let me know if I got it wrong.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[beadedbytes]

Thanks, Skip, for feedback.

FYI ... I neglected to mention in my initial post that I am using Primary and Secondary axes. Unfortunately, it's not solving my issue. Let me know if you have any other ideas, okay?

BTW, Happy New Year!!

 

[SkipVought]

Can you upload your workbook?

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[SkipVought]

Here are the issues. You have three series that are each widely disparate from the others and each series has widely disparate values...
[pre]
' Qty_Snt Return% Cost_Rate
MAX 4003101 4.82% 987
MIN 9690 0.57% 40
[/pre]

yer talking 2 orders of magnitude difference in each series!

So you have more than one issue here: 3 series that need 3 different values axes and each series needs to display values separated by 2 orders of magnitude.

What is the story that the chart needs to tell?


Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[beadedbytes]

Skip,

The chart is simply a aggregate summary (i.e. 6 months) of results.

I agree with you that the min-max range across fields are are too great. And, have decided to omit the Qty_Sent field from the chart.

Thanks for your help! Let me know if you have any light to shed on my 2nd post.