Excel gurus needed (1 Viewer)

[coyote5]

Hey I need to do a stacked bar graph in excel, with two bars for each time period (monthly)

Source data format:
Month Charges A Charges B Payments A Payments B
Jan
Feb
Mar

Where Charges A and B columns are stacked and Payment A and B are stacked, both bars next to each other for each month... Is this easy to do? Am I missing something in excel? Hint: My old *** is probably missing something LOL. If I use Excel's chart generator, the stacked bar option takes all 4 columns of data and stacks them into a single bar for each month

 

[titusbramble]

Can you not reformat the data to have column headers of Month, Transaction Type and A/B?

 

[Andy Dufresne]

If you type that into ChatGPT it gives a formatted answer that may work:

To create a stacked bar graph in Excel where "Charges A" and "Charges B" are stacked in one bar, and "Payments A" and "Payments B" are stacked in another bar, with both bars side by side for each month, follow these steps:

1. Organize the Data

Ensure your data is structured like this:

2. Create the Chart

1. Highlight the Data: Select the entire dataset, including the headers (e.g., A1:E4 if you have three months of data).


2. Insert a Stacked Bar Chart:

Go to the Insert tab on the ribbon.

Click on the Insert Column or Bar Chart dropdown.

Select Stacked Bar Chart (not 100% stacked).



3. Reorganize Data for Two Bars Per Month:

If Excel stacks all four columns into one bar, you need to adjust the data.

Create a helper table with the following structure:

Leave blank cells to separate the stacked Charges and Payments bars.



4. Update the Chart:

Highlight the new table and create a stacked bar chart again.

This will create two separate stacked bars (Charges and Payments) for each month.




3. Customize the Chart

1. Format the Bars:

Use distinct colors to differentiate "Charges A" and "Charges B," as well as "Payments A" and "Payments B."

Add a legend for clarity.



2. Add Data Labels:

Click on the chart.

Use the + button on the chart to enable data labels for each segment.



3. Adjust Axis and Spacing:

Ensure the x-axis shows months clearly.

Adjust the spacing between the bars if necessary (use the Format Data Series option).




Let me know if you need further clarification!