About Us

SwampYankee

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	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
formatting daily,weekly and monthly schedules	do u c me	New Users to Excel	1	January 11th 07 02:37 AM
formatting daily,weekly and monthly schedules	do u c me	New Users to Excel	1	January 11th 07 02:36 AM
Collecting weekly and monthly totals from daily data	Kasper	Excel Worksheet Functions	0	January 12th 06 08:02 PM
Why won't it Excel fill in weekly dates now, changes them to daily	Larry	Excel Worksheet Functions	1	April 6th 05 12:57 PM
Looking for excel template to log daily/weekly employee activities	Jerome	Excel Discussion (Misc queries)	0	January 7th 05 11:17 AM

Menu

About Us