To Break Y-Axis for multiple data series

  • Follow


Hi,
I have a lot of data in which sometimes data varies too much that some bars 
raise up to 1000s and some remain within 100s. now, to overcome this problem 
I used Peltier Tech’s solution 
(http://peltiertech.com/Excel/Charts/BrokenYAxis.html) to break the y-axis 
which works fine when I used that for single data series. Now the problem is 
my data spans through 8 categories and 12 Months. My data looks something 
like this:

Customers		Jan	Feb	Mar	Apr	May	June
AAA		25	29	12	25	29	12
BBB		26	69	23	26	69	23
CCC		12	23	32	12	23	32
DDD		29	24	70	29	24	70
EEE		19	12	12	19	12	12
FFF		21	10	30	21	10	30
GGG		10	15	16	10	15	16
HHH		9	30	7	9	30	7


Now I am lost, when my data plots over multiple data series within one 
month. Can someone help me here. I need this as soon as possible. For this I 
will be very thankful to you.

-- 
Sheikh Saadi
0
Reply Utf 4/8/2010 11:04:02 PM


0 Replies
846 Views

(page loaded in 0.023 seconds)

Similiar Articles:
















7/19/2012 8:42:43 PM


Reply: