Charts-Scale

DorothyAnderson · Mar 6th, 2002, 01:55 PM

I am trying to use a bar chart for two data series that are largely different (e.g., one is 1,000 and the other is 100,000). Is there any way to chart the data not to scale, or be able to break the scale (e.g., 0-1,000 then 8,000-10,000.

[ This Message was edited by: DorothyAnderson on 2002-03-06 12:56 ]

scwyj · Mar 6th, 2002, 02:51 PM

You might try formatting some of the data series to use the secondary axis.

sc

Mark W. · Mar 6th, 2002, 03:53 PM

Would a logarithmic scale work?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 6th, 2002, 01:55 PM	#1
DorothyAnderson New Member Join Date: Mar 2002 Posts: 1	I am trying to use a bar chart for two data series that are largely different (e.g., one is 1,000 and the other is 100,000). Is there any way to chart the data not to scale, or be able to break the scale (e.g., 0-1,000 then 8,000-10,000. [ This Message was edited by: DorothyAnderson on 2002-03-06 12:56 ]

Mar 6th, 2002, 02:51 PM	#2
scwyj New Member Join Date: Feb 2002 Location: East Sussex Posts: 33	You might try formatting some of the data series to use the secondary axis. sc

Mar 6th, 2002, 03:53 PM	#3
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	Would a logarithmic scale work?