Oct 26, 2015 · Re: How to split a line graph two part? The chart itself cannot split a data series, but you should be able to split the data series in the spreadsheet and/or in your series definition. So, define your series one to be the first two or three points, then define series 2 …

Oct 27, 2005 · All, I can't find a way to break a three year/12 qtr trendline apart in Excel Charts. I'd like to have one trendline for the first two years (8 qtrs) and one for the last year (4 qtrs).

May 25, 2006 · The legend in my chart has about 8 items and I cannot get them to split into two columns. The legend is subsequently very tall and has to go at the bottom of the chart as company standard so is making the chart look unprofessional.

May 22, 2012 · Re: How to split the Y-axis values in the graph ? Broken axis in my opinion is the best solution, but aybe adding a secondary y-axis will be o.k also. I've split the data into 2 series, each with different scale. one to the higher values, and the other to the lower values.

Jul 8, 2005 · I need to create a bar chart using the following data: Column1 = 2 (value inside cell) Column2 = 3 (value inside cell) Coumn3 = 5 (=column1 + column2) Here's the layout I'm looking for: bar1 would start at 0(zero) and stop at 2 bar2 would start at 3 and stop at 5 (nothing would show below 3 for this bar)

May 10, 2009 · I'm trying to create a bar graph containing 2 types of data. So one column split into two sections. One portion should be value 'A' (percentage out of 100%) and value 'B' (a number of minutes). I need the graph to acurately show the value in percentage and the number on the second half of the bar should calculate (visibly) the difference from 100%.

Mar 26, 2013 · Hi, I have made a column graph to show frequency (y-axis) within different ranges (x-axis). I want to put dotted vertical lines to separate the graph into 3 sections corresponding to my 3 treatment times for illustration purposes.

Apr 27, 2005 · How can I split the scale so the small data doesn't get lost? Can the scale be split to show 0 - 500 (increments of 25) then 500 - 15,000 (increments of 5,000)? How do I split the y-axis scale on a chart?

May 24, 2006 · Join Date 06-22-2004 Location Surrey, England MS-Off Ver Excel 2013 Posts 4,967

Mar 29, 2009 · Join Date 06-20-2007 Location The Great State of Texas MS-Off Ver 2010, 2019 Posts 40,689