Creating Charts - Avoiding autofill of dates, adjusting width, and stopping overlap

sheranic

New Member
Joined
Oct 20, 2015
Messages
1
I was at work the other day, coincidentally creating a combo column/line chart on the migration from Office 2010 to 2013, and had some issues creating a chart that looked decent. This was on Win 7 x64 Enterprise with Office 2013 Pro Plus x86.

Example data below

Version20102013NoneTotal
4-Sep31257671306209
11-Sep21358621506225
18-Sep12459921506266
25-Sep2360931526268

<colgroup><col width="64" style="width:48pt" span="5"> <tbody>
</tbody>



<tbody>
</tbody><colgroup><col><col><col span="2"><col></colgroup>

I had three problems

1. The columns were all very skinny with a lot of white space between the dates. Tweaking the Series Overlap and Gap Width did not correct this.
2. Excel autofilled all of the days between 9/4 to 9/11 and 9/11 to 9/18, etc. further exacerbating the issue above.
3. When I plot 2013 and Total (line) on a secondary axis, leaving 2010 and None on the primary, the 2013 column overlaps the 2010 and None columns.


I just tried to repeat these issues on my home system (Win 10 Home x64 with Office Pro Plus 2013 x64), but 1. and 2. were not issues on my personal laptop.

I also found a work around that has you add 2 empty columns between the data columns to act as "Padding" so the columns you want to see overlaps the blank data. Then just delete the legend entries for the padding columns and tweak the Overlap and Gap settings for the series. The table would then look like below. It works, but seems like that can't be the REAL solution.

Version2010padding 2010Padding 20132013Padding 2013Padding NoneNoneTotal
4-Sep312 5767 1306209
11-Sep213 5862 1506225
18-Sep124 5992 1506266
25-Sep23 6093 1526268

<tbody>
</tbody><colgroup><col span="2"><col span="2"><col><col><col><col span="2"></colgroup>


<tbody>
</tbody><colgroup><col><col><col span="4"></colgroup>
 

Some videos you may like

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

Watch MrExcel Video

Forum statistics

Threads
1,123,177
Messages
5,600,160
Members
414,367
Latest member
dw970906

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top