Need large gap in chart



  • 1. hypsographic curve
    Does anyone know how to manipulate data to create a hypsographic curve similar to those found in limnology textbooks. I cannot seem to get the depth on the y scale and area on the z scale.
  • 2. how to generate a polynomial regression graph with 90% CI?
    How do I add a trend line with the 10th, 50th and 90th percentiles to a scattergram graph?
  • 3. Excel 2007 Bug
    I have run this code (stripped down code shown below) for over 4 years now in both Excel 97 and 2003. I am now trying out 2007 but the VBA code to create my charts is failing. I have found 2 workarounds but it seems like madness for me to use them. Am I doing something wrong? I think I may be going mad... Option Explicit ' Excel 2007 VBA Bug example ' ' Execute BuggedExcel() Public Sub BuggedExcel() Dim chtChart As Chart Dim FixLevel As Integer FixLevel = 0 'Toggles whether to work-around the Excel 2007 VBA bug. Set chtChart = ActiveSheet.ChartObjects.Add(0, 0, 184, 95).Chart Select Case FixLevel Case 0 'No fix Case 1 Dim x As Integer x = chtChart.PlotArea.Top Case 2 'This fix will only work if you press F5 and not the play button on the toolbar! DoEvents End Select 'The following method (x.Top = 0) fails in Excel 2007 unless the 2 lines above are executed. Works fine in all previous Excel versions. 'When this fails in 2007, if the User clicks Debug they can step through/re-run the exact same lines and the code runs without issues. chtChart.PlotArea.Top = 0 Set chtChart = Nothing End Sub
  • 4. Pie Chart problems
    I have data to be represented by a pie chart and need to include a text box with the grand total of the data somewhere on the chart. I've been able to create an embedded pie chart but can't get the text box with the grand total to stay on the chart when I click off the chart area. Then I tried to create the chart on a chart tab instead of making an embedded chart--I can get the text box to stay on the chart but then I can't get the data to update when it changes (the series values remain the same--it's reading a total row). I need the pie chart to be updated as new data is added AND I need the grand total to be displayed (I assume via a text box). Is it a dream for me to have my cake and eat it too?? :) -- Thanks so much!
  • 5. chart margins
    How do I reduce the margins around a chart?

Need large gap in chart

Postby QW1iZXJpY2FuRGF1Z2h0ZXI » Fri, 10 Dec 2004 05:55:07 GMT

I am making a line graph with 2 sets of numbers that are very far apart - one 
set of numbers is around 7000 to 8000, and the other set is closer to 80,000. 
Of course, I get one line at the top of the chart that is pretty easy to 
read, but the line on the bottom that represents the smaller numbers is just 
TINY and looks pretty much straight.

My question is this: is there a way to put a "break" into the graph between 
the smaller numbered data and the larger ones so they are all easier to read? 
Like a jagged line showing where the jump occurs or something?

Re: Need large gap in chart

Postby Andy Pope » Fri, 10 Dec 2004 05:59:09 GMT


Jon has an example, which includes a couple of links to alternative 

Although the examples are for column charts the principle is the same 
only you only need the break on the axis.



Andy Pope, Microsoft MVP - Excel

Similar Threads:

1.Need gaps, not zeros for charts!

2.Minimize range on vertical axis with large data gaps

I am tracking the percent of sales by product catagory for a company.  They 
have low percents for everything but one area.  I mean, most product areas 
are less than 10% while one is 60%.  I want to remove the distance between 
the 60% product catagory and all the others but still showing accurate data.

I would like to remove 20% - 50% since there is no data for that area.  Is 
that possible?

3.Deleting large gaps in address

I am using a large Excel spreadsheet to address my letters using mail merge.  
When I merge some of the addressee names have multiple spaces between the 
first and the last name.  How can I clear this up in my spreadsheet before I 
merge without doing it manually.

4.Find gaps or breaks in a large column

I have a very large column and I need to find out where the breaks or gaps 
are. Example on the below column #1793675 and 1793682 are not listed. Can you 
please advise a formula to check them?

5.Calculating largest gap in a series of consecutive numbers


I am currently trying to calculate the largest gap in a series of numbers 
where a particular number has not appeared and display this number in a cell.

For example,

There are 2 numbers involved, 0 and 1. My spreadsheet looks like:

A2 1
A3 0
A4 0
A5 0
A6 0
A7 1
A8 0
A9 0 and so on.....

Now, in cell C1 I want excel to automatically calculate the number of times 
0 has come up consecutively up to the last time the number 1 appeared. So 
when inputting data downwards in A10, A11, A12 it will be able to tell me how 
many consecutive 0's there have been until the last number 1 appeared.

In the above example, if I had input the data upto A5, C1 would display the 
number 3 (there have been three 0's since the last 1 came up). When A6 is 
filled in with a 0, C1 would display 4, yet once A7 had been filled in the 
counter would reset back to 0 in C1.

I have tried to explain this as best as I can, if you need any clarification 
please ask, and thank you kindly in advance,

6. I need to copy a large chart from excel

7. Transpose Column With Gaps to Column With no gaps


Return to MS EXCEL


Who is online

Users browsing this forum: No registered users and 73 guest