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.
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
bar chart.xlsx
