Posted to microsoft.public.excel.programming

Vacuum Sealed[_2_] Vacuum Sealed[_2_] is offline

external usenet poster

Posts: 87

Date values not appearing correclty in the x-axis

Hi Kush

you could try adding this:

Dim myDate As String
myDate = Format(Date, "dd-mmm-yyyy")

so replace this:
..axes(xlCategory, xlprimary).axisTITLE.CHARACTERS.TEXT = "Date"

with
..axes(xlCategory, xlprimary).axisTITLE.CHARACTERS.TEXT = myDate

HTH

Mick

Reply With Quote

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

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Chart adds in extra date values on the X axis	Pete Rooney	Charts and Charting in Excel	7	May 2nd 23 11:43 AM
X-Axis Appearing in Plot Area	Mike M.[_2_]	Charts and Charting in Excel	2	October 8th 09 09:23 PM
Data appearing as Values	Polochilde	Excel Discussion (Misc queries)	4	February 28th 07 08:28 PM
Display Values under Date labels on the X-Axis...	Bob Barnes	Charts and Charting in Excel	1	October 7th 05 10:24 PM
How to insert X axis scale values next to axis and X axis grid lin	vp23larry	Charts and Charting in Excel	2	June 23rd 05 03:45 PM

All times are GMT +1. The time now is 07:39 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us