Sir,
Attached is a file where two data are given i need to draw a chart using FY-2001 as in horizontal axis and HV20103 on vertical axis
file with data is attached
Sir,
Attached is a file where two data are given i need to draw a chart using FY-2001 as in horizontal axis and HV20103 on vertical axis
file with data is attached
Last edited by kiany406; 09-18-2012 at 07:53 AM.
see if the attached gives you what you want?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Sir,
Thanks for your reply, if possible please explain how to do it. & also if we can draw a chart in other way also like FY-2001 on horizontal Axis and HV 20103 ON Vertical Axis
Thanks
Creating the chart FDibbins created should be as easy as 1) selecting the data, 2) Insert chart command, 3) In the chart wizard, tell it you want an XY scatter plot.
To switch the x and y data, either switch the columns in the spreadsheet so that the x data (FY20001) is before the y data (HV20103), or, in the source data dialog for the chart, tell it which column is x data and which is y.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks