K keasha Member Jul 9, 2017 #1 hello i am trying to create a chart with a number of variables but i cannot get it to work i am hoping someone can help please ! many thanks Attachments chart1.xlsx 845.1 KB · Views: 2
hello i am trying to create a chart with a number of variables but i cannot get it to work i am hoping someone can help please ! many thanks
Hui Excel Ninja Staff member Jul 9, 2017 #2 do you mean something like: If not describe or draw a picture of what you are after?
K keasha Member Jul 9, 2017 #3 hello hui yes, for the life of me i could not get it to display that way.
Hui Excel Ninja Staff member Jul 9, 2017 #4 Open the file Select D10:H14 Insert, Chart, Clustered Column Goto the Design Tab, Switch Row/Column Click any column and use the up/down arrows until the Pro Rata FTE columns are selected Click the Design Tab, Change Chart Type Select Combo Ok and Enjoy Attachments Copy of chart1-1.xlsx 854.4 KB · Views: 2
Open the file Select D10:H14 Insert, Chart, Clustered Column Goto the Design Tab, Switch Row/Column Click any column and use the up/down arrows until the Pro Rata FTE columns are selected Click the Design Tab, Change Chart Type Select Combo Ok and Enjoy