<div>
Hi,<br />
<br />
Could you send a dummy?<br />
<br />
Regards
</div>


<div>
Rgonzo,<br />
<br />
&nbsp; &nbsp; This is a very simple, easy example. &nbsp;The subject is make believe. &nbsp;The orange and the blue overlap so I can't tell what is going on. &nbsp;I do not want to show two separate charts.<br />
<br />
Thanks,<br />
<br />
Awakenings<br />
<a href="https://filedb.experts-exchange.com/incoming/2016/03_w10/1084349/Example.xlsx" target="_blank" class="file-inline" title="Example.xlsx (14 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>Example.xlsx</a>
</div>


Rgonzo,

    This is a very simple, easy example.  The subject is make believe.  The orange and the blue overlap so I can't tell what is going on.  I do not want to show two separate charts.

Thanks,

Awakenings
Example.xlsx [https://filedb.experts-exchange.com/incoming/2016/03_w10/1084349/Example.xlsx]

Example.xlsx

<div>
On way to solve it is to use a logarithmic scale<br />
<br />
or you could use a Panel Chart <br />
reference<br />
<a href="http://peltiertech.com/Excel/ChartsHowTo/PanelUnevenScales.html" rel="ugc">http://peltiertech.com/Excel/ChartsHowTo/PanelUnevenScales.html</a><br />
<a href="https://filedb.experts-exchange.com/incoming/2016/03_w10/1084351/EE20160302Log.xlsx" target="_blank" class="file-inline" title="EE (13 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>EE20160302Log.xlsx</a>
</div>


On way to solve it is to use a logarithmic scale

or you could use a Panel Chart
reference
http://peltiertech.com/Excel/ChartsHowTo/PanelUnevenScales.html [http://peltiertech.com/Excel/ChartsHowTo/PanelUnevenScales.html]
EE20160302Log.xlsx [https://filedb.experts-exchange.com/incoming/2016/03_w10/1084351/EE20160302Log.xlsx]

EE20160302Log.xlsx

<div>
Sorry for the slow response. &nbsp;This is great! &nbsp;How did you do it? &nbsp;The link shows that you can, but on a practical level how do you change to the logarithmic scale?
</div>


Sorry for the slow response.  This is great!  How did you do it?  The link shows that you can, but on a practical level how do you change to the logarithmic scale?

<div>
<div class="content wysiwyg-content">
I have some very large numbers when creating charts. &nbsp;It is simple to create months and numbers. &nbsp;The issue is the numbers are shrinking rapidly and they end up merging. &nbsp;I was told there was a way to create a chart that cuts out a segment of the data. &nbsp;So I have roughly 30,000, now the numbers are in the 10s. &nbsp;So I can't distinguish the tens. &nbsp;I was told the middle could be cut out to have two different levels showing - one above and one below a line.
</div>
</div>


I have some very large numbers when creating charts.  It is simple to create months and numbers.  The issue is the numbers are shrinking rapidly and they end up merging.  I was told there was a way to create a chart that cuts out a segment of the data.  So I have roughly 30,000, now the numbers are in the 10s.  So I can't distinguish the tens.  I was told the middle could be cut out to have two different levels showing - one above and one below a line.

Microsoft Office Excel Chart Creation Question

Web development can range from developing the simplest static single page of plain text to the most complex web-based internet applications, electronic businesses, and social network services using a wide variety of languages and standards, including the familiar HTML, JavaScript and jQuery, ASP and ASP.NET, PHP, ColdFusion, CSS, PHP, Flex and Flash, but also the implementation of a broad list of standards including XML, WSDL, SSDL, VoiceXML and many more.

Web Languages and Standards

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.