Is there a reason why these bars wont line up in my excel chart

0 votes

That's why I'm having issues. To this bar graph, I've added two extra bars. In the second image, the blue one fits in perfectly with the others. The bar simply lands in front of the other bars when I add the bronze column, though. I have no idea how to repair this. Any guidance is appreciated.

enter image description here

Nov 8 in Others by Kithuzzz
• 20,660 points
39 views

1 answer to this question.

0 votes

STEPS

  1. Hover your mouse over any of the bars in the chart and right click to display the context menu with the following set of options: Context menu: right click
  2. Now select the option right at the bottom - i.e. "Format Data Series..."
  3. This should open the relevant side pane menu bar - vide-licit : Format Data Series side-pane menu bar
  4. Vary the Series Overlap and Gap Width options to resolve - voila! ☺
answered Nov 8 by narikkadan
• 37,660 points

Related Questions In Others

0 votes
1 answer
0 votes
1 answer

Is there a function to unhide columns in excel through python

Excel file : df.to_excel('demofile.xlsx',index=False) import openpyxl py = openpyxl.load_workbook('demofile.xlsx') exlsheet = ...READ MORE

answered Oct 18 in Others by narikkadan
• 37,660 points
84 views
0 votes
1 answer

Is there a coalesce-like function in Excel?

To have Excel analyze the formula as ...READ MORE

answered Oct 21 in Others by narikkadan
• 37,660 points
131 views
0 votes
1 answer
0 votes
1 answer

Excel Pie-Chart in categories

create a pivot pie chart. You can manually ...READ MORE

answered Oct 8 in Others by narikkadan
• 37,660 points
83 views
0 votes
1 answer

Creating a stacked waterfall chart in tableau

You can try this as a solution: 1.) ...READ MORE

answered Apr 5 in Tableau by Vaani
• 7,020 points
390 views
0 votes
1 answer

How to modify Powerpoint Chart ChartData by Excel VBA

Example: Code: Set pptApp = GetObject(, "PowerPoint.Application") Set pptPres = ...READ MORE

answered Oct 16 in Others by narikkadan
• 37,660 points
133 views
0 votes
1 answer

Create Graph from data in an excel file

Your first step would be to become ...READ MORE

answered Oct 17 in Others by narikkadan
• 37,660 points
42 views
0 votes
1 answer

Is there a maximum number of formula fields allowed in Excel (2010)

See http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP010073849.aspx for limits on specs it doesn't indicate ...READ MORE

answered Sep 30 in Others by narikkadan
• 37,660 points
57 views
0 votes
1 answer

Is there a way in Microsoft Excel to give specific bins different bin widths when making a histogram plot?

Excel built-in histogram tool only allows equal ...READ MORE

answered Oct 2 in Others by narikkadan
• 37,660 points
69 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP