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
|
|||
|
|||
Column Chart to compare data
This is a basic question, but I'm new to charts. I have the following
information: Hours Billable Hours Worked 9/15 121 128 9/30 159 136 10/15 133 134 I would like to make a column chart to compare the data for each pay period. I would like the horizontal axis to list the dates. I would like each date range to encompass two columns (Hours billable & Hours worked) for that date. I would like to these two columns to be side by side touching. Then I would like a small space and the next date with the two columns corresponding to that date there. I have figured out how to make the basic graph with all the columns touching, but I would like to separate them out by date and I can't get the horizontal axis to list the dates out. Any suggestions? Thanks! |
#2
|
|||
|
|||
Column Chart to compare data
Select all your data. Open the chart wizard, create a clustered column chart.
Once you have the chart created you may need to adjust the x-axis. If you only want the dates you listed to be displayed, right-click on chart, chart options. Go to the axis tab, and select "category" under the x-axis. If you want a time-scale axis (with all calendar dates) choose "time scale" -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "BrookieOU" wrote: This is a basic question, but I'm new to charts. I have the following information: Hours Billable Hours Worked 9/15 121 128 9/30 159 136 10/15 133 134 I would like to make a column chart to compare the data for each pay period. I would like the horizontal axis to list the dates. I would like each date range to encompass two columns (Hours billable & Hours worked) for that date. I would like to these two columns to be side by side touching. Then I would like a small space and the next date with the two columns corresponding to that date there. I have figured out how to make the basic graph with all the columns touching, but I would like to separate them out by date and I can't get the horizontal axis to list the dates out. Any suggestions? Thanks! |
#3
|
|||
|
|||
Column Chart to compare data
Probably a time-scale axis is not good here. The dates are weekly, so
there would be a six-day gap between each one day of data. The trick is to make sure there is a nonzero gap width, which is the distance between adjacent clusters of columns. - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ Luke M wrote: Select all your data. Open the chart wizard, create a clustered column chart. Once you have the chart created you may need to adjust the x-axis. If you only want the dates you listed to be displayed, right-click on chart, chart options. Go to the axis tab, and select "category" under the x-axis. If you want a time-scale axis (with all calendar dates) choose "time scale" |
Thread Tools | |
Display Modes | |
|
|