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
|
|||
|
|||
Weekly bar charts assumes i mean daily bar chart
Hi,
I'm trying to creat a simple bar chart that shows open tickets and closed tickets week by week. I have 3 weeks of data and the bars themselves are ok (20 open 6 closed). However, when using the date as the horizontal axis, Excel inserts the 6 days of the week between each miles stone. So, if I want to see the number of tickets each Monday, Excel creates the chart with all the other days of the week, which have no data. I'm left with 3 bars standing apart. How can I get each Monday to stand next to each other and hide the intevening days? P.S. The cells the chart is based on do not contain the intevening days. thanks |
#2
|
|||
|
|||
Weekly bar charts assumes i mean daily bar chart
Then, go to Chart Options, Axes Tab
Change X Axis to Category "SwampYankee" wrote: Hi, I'm trying to creat a simple bar chart that shows open tickets and closed tickets week by week. I have 3 weeks of data and the bars themselves are ok (20 open 6 closed). However, when using the date as the horizontal axis, Excel inserts the 6 days of the week between each miles stone. So, if I want to see the number of tickets each Monday, Excel creates the chart with all the other days of the week, which have no data. I'm left with 3 bars standing apart. How can I get each Monday to stand next to each other and hide the intevening days? P.S. The cells the chart is based on do not contain the intevening days. thanks |
#3
|
|||
|
|||
Weekly bar charts assumes i mean daily bar chart
|
#5
|
|||
|
|||
Weekly bar charts assumes i mean daily bar chart
In article ,
says... In Excel 2007, select the axis and press the Ctrl+1 (numeral one) shortcut to open the format dialog. On the dialog tab that lets you set the axis scale, change the 'date scale' selection to 'text' or 'category' (I forget the new nomenclature). - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "SwampYankee" wrote in message . .. In article , says... Then, go to Chart Options, Axes Tab Change X Axis to Category "SwampYankee" wrote: Hi, I'm trying to creat a simple bar chart that shows open tickets and closed tickets week by week. I have 3 weeks of data and the bars themselves are ok (20 open 6 closed). However, when using the date as the horizontal axis, Excel inserts the 6 days of the week between each miles stone. So, if I want to see the number of tickets each Monday, Excel creates the chart with all the other days of the week, which have no data. I'm left with 3 bars standing apart. How can I get each Monday to stand next to each other and hide the intevening days? P.S. The cells the chart is based on do not contain the intevening days. thanks To clarify I am using Excel 2007, I don't know if this makes a difference but I right clicked on the chart and don't see a 'chart- options'. However, I think what you are suggesting is to switch the X and Y axis. In 2007 this is done with the select data option. However, it does not give me the chart I want. I want to have the X axis show a week, and the Y axis show bar representing a number of units. Switching the Axis gives me a chart that shows the dates on the Y axis and the number on the X axis. That did it! Thanks, chart looks great now. |
Thread Tools | |
Display Modes | |
|
|