Adjusting Column Size in Clustered Column Chart

[QuantamPulse]

Is there any way to manually control the column width for a clustered column chart? As it stand, there is way to much whiote space in each side of the chart. When I try to lower it down, the column size shrinks as well. Makes it to where its either hard to see what the data shows or there is a ton of white space on either side of the chart. 

[Anonymous]

Hi @QuantamPulse 

Thanks for the reply from dharmendars007 .

@QuantamPulse , Are you trying to change the width of column? If so, you might be able to use the R visualization. The following testing is for your reference.

Select the R visualization and enter the following in the R script editor.

# Load the ggplot2 package
library(ggplot2)
 
# Create a sample data frame
data <- data.frame(
  Country = c("A"),
  Profit = c(9)
)
 
# Create a bar chart with adjusted bar width
ggplot(data, aes(x = Country, y = Profit)) +
  geom_bar(stat = "identity", width = 1) +  # Adjust the width parameter as needed
  theme_minimal() +
  labs(title = "Bar Chart with Adjusted Width",
       x = "Country",
       y = "Profit")

You can change the width of the column by changing the value of width. Click to run

Output:

Best Regards,
Yulia Xu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[dharmendars007]

Hello @QuantamPulse , 

Try Adjusting the "Inner padding" size , Lowering this value will make the bars thicker and reduce white space between bars within a category.

If you find this helpful , please mark it as solution and Your Kudos are much appreciated!

Thank You

Dharmendar S

LinkedIN 

[QuantamPulse]

Tried adjusting the padding and its didn't do anything to solve the issue. For further clarification, the issue lies with this space on the chart. 

I need to be able to remove that space to add more room for the chart. 

[dharmendars007]

Hello @QuantamPulse , 

There is no native way reducing the space, but you can adjust the position of the legends in the visual.

If you find this helpful , please mark it as solution and Your Kudos are much appreciated!

Thank You

Dharmendar S

LinkedIN 

[QuantamPulse]

That doesnt do me any good either. I need to have three of these charts side by side due to data filtering. With so much white space in there, it leaves huge gaps and makes the data hard to read. Figures that MS couldn't have a solution for a simple problem. You can even do it in Excel.