chart problems

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am creating charts in my reports. There are several charts all with the
same problems. The x axis source is the date/time field. The dates are not
sorting in order.

They are coming:
1/1/05 2am, 1/10/05 2am...etc.

I can't seem to format the date to accept the zero in front of the one to
make it 1/01/05.
format: "dddddd hampm"
Any help would be appreciated. Thanks
 
What is the SQL of the chart's Row Source property. Sort this and your chart
should sort properly.
 
You must log in or register to reply here.

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

Creating Scatter Graph Pivot Chart without autocal on (x,y) values 2
Problem formatting dates from CSV file 2
How to enter start and end date/time in excel based on some specific value. 7
Excel 07 Charts 1
new user 3
Formatting pivot chart axis labels for dates 10
if then on chart 2
Combine 2 Charts 2007 Excel 1

Back
Top