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


+-------------------------------------------------------------------+
|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

You could use a horizontal bar chart


--
Dnereb
------------------------------------------------------------------------
Dnereb's Profile: http://www.excelforum.com/member.php...o&userid=26182
View this thread: http://www.excelforum.com/showthread...hreadid=396808

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" wrote in message
...

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


--
mihai
------------------------------------------------------------------------
mihai's Profile: http://www.excelforum.com/member.php...fo&userid=2808
View this thread: http://www.excelforum.com/showthread...hreadid=396808