Creating Clustered Chart in Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2064757%22%20slang%3D%22en-US%22%3ECreating%20Clustered%20Chart%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2064757%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20pretty%20new%20to%20Excel%20and%20need%20to%20build%20a%20clustered%20chart%20for%20appointment%20resource%20data.%20Below%20is%20a%20snip%20of%20the%20data%20in%20the%20layout%20I%20have%20to%20work%20with.%20Each%20appointment%20type%20is%20provided%20from%205%20minutes%26nbsp%3Ball%20the%20way%20to%20greater%20than%2030%20minutes.%20There%20should%20be%20a%20bar%20for%20each%20duration%20on%20each%20date%20it%20was%20used.%20Can%20someone%20please%20show%20me%20how%20to%20display%20this%20so%26nbsp%3Beach%26nbsp%3Bappointment%20duration%20appears%20as%20its%20own%20bar%20representing%20the%20daily%20total%26nbsp%3Bover%20each%20date%20it%20was%20used%3F%20The%20first%20screen%20shot%20shows%20the%20data%20set%20I%20have%20to%20work%20with.%20The%20second%20is%20the%20resulting%20chart%20I%20get.%20I%20can't%20seem%20to%20get%20the%20data%20to%20display%20correctly.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJust%20for%20clarity%2C%2012%2F1%2F2020%20shows%205%20appointments...%20a%20single%2010-minute%20appointment%2C%203%2015-minute%20appts.%2C%20and%20a%20single%2020-minute%20appt.%20The%20Total%20column%20represents%20how%20many%20of%20that%20duration%20on%20that%20date.%20Thanks%20in%20advance.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22ApptData.JPG%22%20style%3D%22width%3A%20223px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F246698i49ACADA5152790FD%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22ApptData.JPG%22%20alt%3D%22ApptData.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Chart.JPG%22%20style%3D%22width%3A%20660px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F246700iE9C076A0C6A00A94%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Chart.JPG%22%20alt%3D%22Chart.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2064757%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2064955%22%20slang%3D%22en-US%22%3ERe%3A%20Creating%20Clustered%20Chart%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2064955%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F930697%22%20target%3D%22_blank%22%3E%40DonaldCopp71%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EClick%20anywhere%20on%20the%20chart%20to%20select%20it.%3C%2FP%3E%0A%3CP%3EActivate%20the%20Design%20tab%20of%20the%20ribbon%2C%20under%20'Chart%20Tools'.%3C%2FP%3E%0A%3CP%3EIn%20the%20Data%20group%2C%20click%20'Select%20Data'.%3C%2FP%3E%0A%3CP%3EUnder%20'Legend%20Entries%20(Series)'%2C%20select%20the%20Duration%20series%20and%20click%20Remove.%3C%2FP%3E%0A%3CP%3EUnder%20'Horizontal%20(Category)%20Axis%20Labels'%2C%20click%20Edit.%3C%2FP%3E%0A%3CP%3EYou%20will%20see%20something%20like%20Sheet1!%24A%244%3A%24A%2425%20(the%20latter%20number%20depends%20on%20your%20actual%20data).%3C%2FP%3E%0A%3CP%3EChange%20the%20second%20A%20to%20B%3A%20Sheet1!%24A%244%3A%24B%2425.%3C%2FP%3E%0A%3CP%3EClick%20OK%2C%20then%20click%20OK%20again.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I'm pretty new to Excel and need to build a clustered chart for appointment resource data. Below is a snip of the data in the layout I have to work with. Each appointment type is provided from 5 minutes all the way to greater than 30 minutes. There should be a bar for each duration on each date it was used. Can someone please show me how to display this so each appointment duration appears as its own bar representing the daily total over each date it was used? The first screen shot shows the data set I have to work with. The second is the resulting chart I get. I can't seem to get the data to display correctly.

 

Just for clarity, 12/1/2020 shows 5 appointments... a single 10-minute appointment, 3 15-minute appts., and a single 20-minute appt. The Total column represents how many of that duration on that date. Thanks in advance.

 

ApptData.JPG

 

Chart.JPG

1 Reply

@DonaldCopp71 

Click anywhere on the chart to select it.

Activate the Design tab of the ribbon, under 'Chart Tools'.

In the Data group, click 'Select Data'.

Under 'Legend Entries (Series)', select the Duration series and click Remove.

Under 'Horizontal (Category) Axis Labels', click Edit.

You will see something like Sheet1!$A$4:$A$25 (the latter number depends on your actual data).

Change the second A to B: Sheet1!$A$4:$B$25.

Click OK, then click OK again.