If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
To Break Y-Axis for multiple data series
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 |
Thread Tools | |
Display Modes | |
|
|