If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Stacked Column Chart
I am trying to do a stacked column chart, but it's not working and I've tried
everything. So the only thing I can think of is maybe a stacked column chart will not work in this instance. Here is a sample of the information I'm trying to do. Employee Name Jan Billed Jan PTO Feb Billed Feb PTO Mar Billed Mar PTO John Doe 24 8 36 0 22 3 What I'm trying to show is a stacked column that shows how many hours we billed for January and on top of that how many hours PTO they took for January. I want the horizontal axis to be the months. What is happening is it is creating a separate column for billed and one for PTO. Anyone know how I can fix this? Thanks! |
#2
|
|||
|
|||
Stacked Column Chart
I have just put up a file for you at:-
http://www.pierrefondes.com/ It is item number 63 towards the top of my home page. Look at Sheet2. Is this what you want? Where do you want the John Doe to go? Please hit Yes if my comments have helped. Thanks. "BrookieOU" wrote: I am trying to do a stacked column chart, but it's not working and I've tried everything. So the only thing I can think of is maybe a stacked column chart will not work in this instance. Here is a sample of the information I'm trying to do. Employee Name Jan Billed Jan PTO Feb Billed Feb PTO Mar Billed Mar PTO John Doe 24 8 36 0 22 3 What I'm trying to show is a stacked column that shows how many hours we billed for January and on top of that how many hours PTO they took for January. I want the horizontal axis to be the months. What is happening is it is creating a separate column for billed and one for PTO. Anyone know how I can fix this? Thanks! |
#3
|
|||
|
|||
Stacked Column Chart
That is perfect!!! Thank you sooo much. I can put the name as the chart
title. Thank you again! "trip_to_tokyo" wrote: I have just put up a file for you at:- http://www.pierrefondes.com/ It is item number 63 towards the top of my home page. Look at Sheet2. Is this what you want? Where do you want the John Doe to go? Please hit Yes if my comments have helped. Thanks. "BrookieOU" wrote: I am trying to do a stacked column chart, but it's not working and I've tried everything. So the only thing I can think of is maybe a stacked column chart will not work in this instance. Here is a sample of the information I'm trying to do. Employee Name Jan Billed Jan PTO Feb Billed Feb PTO Mar Billed Mar PTO John Doe 24 8 36 0 22 3 What I'm trying to show is a stacked column that shows how many hours we billed for January and on top of that how many hours PTO they took for January. I want the horizontal axis to be the months. What is happening is it is creating a separate column for billed and one for PTO. Anyone know how I can fix this? Thanks! |
#4
|
|||
|
|||
Stacked Column Chart
No problemo. A pleasure!
"BrookieOU" wrote: That is perfect!!! Thank you sooo much. I can put the name as the chart title. Thank you again! "trip_to_tokyo" wrote: I have just put up a file for you at:- http://www.pierrefondes.com/ It is item number 63 towards the top of my home page. Look at Sheet2. Is this what you want? Where do you want the John Doe to go? Please hit Yes if my comments have helped. Thanks. "BrookieOU" wrote: I am trying to do a stacked column chart, but it's not working and I've tried everything. So the only thing I can think of is maybe a stacked column chart will not work in this instance. Here is a sample of the information I'm trying to do. Employee Name Jan Billed Jan PTO Feb Billed Feb PTO Mar Billed Mar PTO John Doe 24 8 36 0 22 3 What I'm trying to show is a stacked column that shows how many hours we billed for January and on top of that how many hours PTO they took for January. I want the horizontal axis to be the months. What is happening is it is creating a separate column for billed and one for PTO. Anyone know how I can fix this? Thanks! |
Thread Tools | |
Display Modes | |
|
|