Grouping series data together in a bar chart

devoe

New Member
Joined
Oct 28, 2006
Messages
1
Is there a way to create a bar chart with 5 series and have the data points in each series be grouped togther? For example, series 1 will show 5 bars togther, then series 2 will show its bars, followed by series 3 and so on. I'm creating a bar chart that shows a Name, Expiry Date, and a Status. I want The Status to be the series names (Assessing, No Action, Relocate, Close).

Thank you for any assistance :confused:
 

Some videos you may like

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

Watch MrExcel Video

Forum statistics

Threads
1,113,861
Messages
5,544,723
Members
410,630
Latest member
JFORTH97
Top