Amazing Tips About Why Is My Bar Chart So Skinny Add Equation Line To Excel

I have created a bar chart which shows the value for my items.

Why is my bar chart so skinny. An hsbc analyst asked me how to quickly fix skinny bar charts and skinny column charts that sometimes pop up in his decks. Switch back to dates and i've got skinny. It seems to be a problem with how pandas and matplotlib work together.

I'm using excel 2007 and the bar charts created in previous versions of excel are okay, just the ones created using 2007. A format data series dialog box will appear on the side of the excel sheet. If i convert from date to text axis i get the fat bars i want but the axis values get all screwed up.

I will have to come up with a method to display my data in some other format. The chart has a full quarter's worth of data by week. If i only use the axis the visual shows the bars in the right size.

That happens when there is a legend value in the chart that is the same as the y axis. When setting it to 1.0 or higher, it gets interpreted as a width for one week. The bars on the bar chart are very thin even though i have ample space between the axis marks.

The 'no' column is showing as. I've tried all kinds of formatting options and i can't fix this. My problem is i'm running up against the resolution of the electronic image.

In series options, set the gap. It seems to be tied to my axis settings. Sometimes he was able to fix them,.

It creates a bar for each legend item but there is only 1 bar with values in it. Here, you can see the chart bar width is too thin. It creates a bar for each legend item but there is only 1 bar with values in it.

Select the format data series option from the context menu. Using the following data to create a bar chart displays incorrect bar widths. The bars have a border because they look too skinny without a border.

When dealing with a skinny chart in powerpoint or excel, you can tell you have a gap width issue if your categories align perfectly over the bars or columns within your chart. I have found various people saying how to do it and the answer does work to some degree but not. If i also use a legend the visual only.

As you can see, the widths for c are incorrect.