category axis - date

O

oldLearner57

hi community

can anybody kindly assist me in this..

i plotted a data for 5 days (workdays - Monday to Friday) and when I
selected the tabulated and plotted a chart (line chart)

the plotted chart displayed out the whole week for me (Monday - Sunday) as
well. How can I remove the two days (Saturday and Sunday) away from the
category axis

10s community

by the way, I am using Excel 2007 version

10s again for the help

:)
 
A

Andy Pope

Hi,

You need to tell the chart to plot the axis as Category rather than Time
series.

For xl2007 select the axis, CTRL+1 to display Format dialog.
Select Axis Options
Axis Type: Text axis

Cheers
Andy
 
S

ShaneDevenshire

Hi,

It sounds like you are defining the category axis as a date. Instead change
the axis option to "Category". This is the 3rd step of the chart wizard, on
the Axis tab.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to implement two shifts per day with multiple teams 0
Scatter chart with categories on x-Axis 2
removal weekend - chart 2007 1
Bizarre chart behaviour when changing axis cross at points 2
z-order of various lines and bars in an Excel 2007 chart 0
time claimed 2
change chart primary horizontal axis label or name 1
How to change order of drop lines relative to the plotted data inExcel 2007 chart 0

Top