Accentuate diference between two values

Hi

I have for each date two values. A big one and a little one. One the chart the little values are almost not visible. How can I accentuate the difference between the two values? How to scale one series? I use a combined chart. See attachment.

Thank's
Mihai

You could use a horizontal bar chart

Use a second y-axis and change the scale as needed
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"mihai" <[email protected]> wrote in message
news:[email protected]...
>
> Hi
>
> I have for each date two values. A big one and a little one. One the
> chart the little values are almost not visible. How can I accentuate
> the difference between the two values? How to scale one series? I use a
> combined chart. See attachment.
>
> Thank's
> Mihai
>
>
> +-------------------------------------------------------------------+
> |Filename: accentuate difference.zip |
> |Download: http://www.excelforum.com/attachment.php?postid=3700 |
> +-------------------------------------------------------------------+
>
> --
> mihai
> ------------------------------------------------------------------------
> mihai's Profile:
> http://www.excelforum.com/member.php...fo&userid=2808
> View this thread: http://www.excelforum.com/showthread...hreadid=396808
>

The idea of a second y-axis and to change the scale worked perfect.

Thank you Bernard Liengme

Regards
Mihai