Hello Again,
I did figure out some of it, but things do not appear as consistant as 2003. I guess just ignore me for now. Let me play and see if I get get more of this figured out in 2007.
Thanks,
david
From: David <who1012000@yahoo.com>
To: ExcelVBA@yahoogroups.com
Sent: Saturday, September 17, 2011 11:15 AM
Subject: [ExcelVBA] Excel 2007
Hello Everyone,
I am fairly new to 2007 and am trying to create a chart and use some VBA with the chart. When I simply highlight the data; Date (Col A), Volume (Col F), and a couple of averages(Cols H,I,J), the chart does not figure out that the Date should be on the X-axis, it simply numbers the series.
I am use to using 2003 and never had this problem, where the date was not recognized as the x-axis. I can figure out how to Delete the Series numbers on the x-axis, but I can not figure out how to get the Dates on it. It shows in the Series Volume twice. The dates are all weird looking like "10/23/7375", although the selected cells are correct and formatted correctly "10/23/2011." The last date is showing as "1/0/1900."
The second Volume is right along the Y-axis as if it is all 0?
Anyone have some insight on this situation? The file is coming from a 2003 version and is in Compatibility mode at this time.
Thanks,
David
[Non-text portions of this message have been removed]
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Tidak ada komentar:
Posting Komentar