Excel Bar Chart

Resolved · Medium Priority · Version 2010

Thu 8 Dec 2016, 16:35 Delegate Andrew said...

Andrew has attended:
Excel Advanced course
Excel VBA Intro Intermediate course
Excel Advanced - For Power Users course
Excel Dashboards for Business Intelligence course

Excel Bar Chart

I have a bar chart showing Jul - Nov on the x axis with a series of bars that represent values a, b, c in each of the 5 month period (Jul - Nov).
In November, a new value 'd' needs to be added the chart but when I attempt it, excel put's the d value in Jul and not in Nov.

I know that a workaround would involve 0.0 values for each month up to November, but is there another way? Note: No values existed for d before November.

Fri 9 Dec 2016, 09:11 Trainer Jens said...

RE: Excel Bar Chart

Hi Andrew,

Thank you for the forum question.

I do not know how you have organised the source data for the chart, but it shouldn't be a problem to add a value "d" to November.

I have attached a workbook with a couple of examples. If you click on the outside boarder of the charts Excel will put blue boarders around the values in the source table. Drag the handle in the bottom right corner to include the "d" value column or row.

PLease let me know if this answer do not help you.

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Attached files...

bar chart.xlsx

Mon 12 Dec 2016, 09:26 Delegate Andrew said...

RE: Excel Bar Chart

Thank you for replying so swiftly.

This work perfectly. It's a bit obvious when you look at it but I couldn't for the life of me work it out at the time.

Kind regards,

Andrew

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Hide separate columns in Excel 2010

If you want to hide columns not adjacent to each other for example, Columns A, C and E then:-

1) Click on the fist column to be hidden i.e. A

2) Press and hold down the CTRL key

3) While holding the CTRL key, left click on the rest of the columns you want to hide i.e. C and E

4) Right click and choose Hide

View all Excel hints and tips