PC Review

Thread Tools Rate Thread

To Break Y-Axis for multiple data series

Sheikh Saadi
Posts: n/a
      9th Apr 2010
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
Reply With Quote

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Using "break" to Break Out of Multiple Loops in One Call O.B. Microsoft C# .NET 19 19th Feb 2008 02:38 PM
chart with two data series and two colors for each data series bikash Microsoft Excel Charting 0 17th Jan 2008 03:04 AM
Break cell into multiple lines by line break =?Utf-8?B?Q2hpYQ==?= Microsoft Excel Misc 1 20th Aug 2006 06:37 AM
Displaying single and multiple data series.Single data series Donald Macleod Microsoft Excel Charting 2 30th Jan 2006 03:52 AM
series graph -- one series being added to another series rich zielinski via OfficeKB.com Microsoft Excel Charting 3 30th Mar 2005 06:23 PM




All times are GMT +1. The time now is 07:29 PM.