[AccessD] Help With Charts Urgent - x posted

Paul,

An easiy(ish) way to get it perfected in Excel (if you are not too 
familiar with the object model) is to run a macro whilst creating the 
chart object (using the wizard) and then follow the created code to see 
what you need to change.

In terms of this problem...
If you use the Chart wizard to create your chart in Excel, and then (in 
step 2 of 4) select the 'SERIES IN : (columns/row - depending)' radio 
button, and on the next tab of that same step in the wizard, remove the 
axis series...it will go someway to helping you with this problem.

HTH,

Cheers,
Ryan
 






paul.hartland at fsmail.net
Sent by: accessd-bounces at databaseadvisors.com
01/03/2004 11:17
Please respond to Access Developers discussion and problem solving 

 
        To:     accessd <accessd at databaseadvisors.com>
        cc: 
        Subject:        [AccessD] Help With Charts Urgent - x posted


To all,
 
Here we go, always wondered when I would be asked to produce a chart in 
Excel.  So I need all the help I can get here please.  I have a file in 
Excel I have managed to select the columns that I want to use for the 
chart which are Job Number, Count Rate and Target and I have managed to 
produce a basic grid.  But it's not quite how I want it to appear, the 
chart is including the job number in the chart when I actually want the 
job number at the bottom of the chart (x axis). 
 
Can anyone tell me how to use the Job Number as the x axis.
 
Thanks in advance for all your help.
 
Paul Hartland
Freeserve AnyTime - HALF PRICE for the first 3 months - Save £7.50 a month 

www.freeserve.com/anytime
-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



 

  
This e-mail and any attachment are confidential and contain proprietary information, some or all of which may be legally privileged.  It is intended solely for the use of the individual or entity to which it is addressed.  If you are not the intended recipient, please notify the author immediately by telephone or by replying to this e-mail, and then delete all copies of the e-mail on your system.  If you are not the intended recipient, you must not use, disclose, distribute, copy, print or rely on this e-mail.

Whilst we have taken reasonable precautions to ensure that this e-mail and any attachment has been checked for viruses, we cannot guarantee that they are virus free and we cannot accept liability for any damage sustained as a result of software viruses.  We would advise that you carry out your own virus checks, especially before opening an attachment.

The UK firm Ernst & Young LLP is a limited liability partnership registered in England and Wales with registered number OC300001 and is a member practice of Ernst & Young Global.  A list of members' names is available for inspection at 1 More London Place, London, SE1 2AF, the firm's principal place of business and its registered office.