LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 66
Default Dates in Chart Axis

I am trying to create 10 charts auomatically from sequential pages. The data
is simple; dates in Column A, titles accross the top, and values in the body.
6 lines of data. I ran the wizard and picked up most of the coding. However,
when the code runs it does not give the dates consistently at the bottom of
the charts. Do I assign the xValue or am I barking up the wrong tree? I
can't figure out the code format or I must be somethiong withthe xvalue
statemnet. I eventually want to assign the colors and line size based on the
category, but i can't get past first base!

If any one has an example of this process and possibly assigning colors I'd
REALLY appreciate it!

Thanks




 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
bar chart with dates on the x-axis overgaard92 Charts and Charting in Excel 4 June 8th 09 12:07 AM
dates on scatter chart axis Jake Charts and Charting in Excel 1 January 26th 08 04:55 PM
Chart Dates on X Axis Bill Martin Excel Discussion (Misc queries) 0 February 14th 06 04:01 PM
Help with Dates on Y Axis of a chart Eric Charts and Charting in Excel 1 August 2nd 05 12:02 AM
xy-chart with dates on x-axis arno Excel Programming 0 April 13th 05 02:42 PM


All times are GMT +1. The time now is 05:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"