#Break In Chart Axis Word 2011 Series In The

Above I simply jumped ahead to a scatter chart without explanation, but anyone who knows me knows I love to explain stuff.Some chart types (such as radar charts) have axes, but they cannot display axis titles. Repeat the last Actual value in the Projected column. Put the Actual data in one column and the Projected data into the next. The better way to make the chart is to start with better data.

First Attempt: Tedious Reformatting Bit by BitI donвЂ™t have MaxвЂ™s data, so I made up my own. Is that possible ?Basically he wants to plot all of his data, with dashed lines for the projected data. What I would like to do is a full line from 2001 to 2018 and a dotted line from 2018 to 2025 to 2030 to 2040. BackgroundI came across this tweet, where Max wanted help with an Excel chart:I have a population data for 2001 to 2018 and projected population data for 2025, 20 only. This approach is available on Windows and Mac OS X only if MS Office 2010.ItвЂ™s not hard to do, you just need to know some data layout and chart formatting tricks.

Break In Chart Axis Word 2011 Series In The

Put the Actual data in one column and the Projected data into the next. The Right Way: Separate Series for Actual and ProjectedThe better way to make the chart is to start with better data. Then reformat the rest of the projected line segments.This chart wasnвЂ™t too hard to do, but imagine if you had dozens of line segments to reformat? Hard enough to select each itty bitty one, then your brain begins to turn into mush from the repetition. When individual points re formatted differently, and there is only one series in the chart, Excel helpfully changes the legend to show each individual point, taking up half the chart.No big deal, the legend is redundant anyway, so delete it. So far, so good, except that legend went a bit funny. I made a simple chart of this data, using a chart type of Scatter with Straight Lines.Then I selected the first line segment for the projected data (select one line segment by selecting the entire line with one click, and selecting the specific line segment with a second click), and I formatted it to have dashed lines.

I know youвЂ™d like to use Scatter with Smooth Lines, and for this example it wouldnвЂ™t make much difference. Treating these years as labels, the widely spaced projections are still plotted one slot apart, so the orange projected line does not extend smoothly from the actual data.So use Scatter with Straight Lines as your chart type. So the first part of the chart has data every year, and it looks okay, but then the projected data comes at irregular intervals (7, 5, and 10 years). ExcelвЂ™s line charts donвЂ™t treat the X values as numerical data, but as text labels. Above I simply jumped ahead to a scatter chart without explanation, but anyone who knows me knows I love to explain stuff.HereвЂ™s what happens when you try to make a line chart, which is the first thought most users have, until theyвЂ™ve been burned.

Break In Chart Axis Word For Mac 2011