how to get week number in month in excel ?

Can anyone help?  I have a scatter graph charting information from 3 columns,
ID No., Rank and volume.  I only use ID. No as I would like to use the number
as a data label in my chart.
The X-Axes of the chart is Dealer No and Rank, but the heading of the axes

I have drawn an XYscatter chart connected with smooth lines. I want to get
the corresponding value on X axis at a know value of Y (50%) how can I do it?
Is it possible to show the calculation by perpendicular dropping lines?

how can i find the coordinatres of the maximum point on a curve plotted in
excel????

My chart has y-axis values on a scale from 10 to 100 in increments of 10 per
each tic.  When I set the scale to logarithmic, the only two tic values left
appearing on the axis are 10 and 100.  How do I get the values 10, 20, 30,
..., 100 all to appear on the axis?

i plot two line chart in the same axis. and i need to find value at the
crossing point of the two chart. how could i find the value by using
microsoft excel

I added Analysis ToolPak from the Add-Ins but it still does not list Data
Analysis under the tools.  Can anyone help?

How do I get the program to use the column I specify from the worksheet to
use as the title  for the points on the chart?

I have created a column that calculates the running total, and i would like
Excel to use only the last value in the list. however, when a new value is
added to the bottom of the list, excel will then take that entry.
Can anybody help.  Thanks

How can I in an easy way convert an excel diagram to be black & white. I have
made a lot of diagrams and realised very late that i will only be able to
print them in black and white. Does anyone know of functionality that lets me
change from the colored diagram, to bars that are ...

I don't understand what it means to List two number formats that allow you to
format the appearance of negative numbers using parentheses?

I have some data that is not a normal distribution.  I would like to draw a
distribution chart of this data

An Excel logarithmic trendline attached to a data series has the following:
    Equation Y=533371Ln(x)-3E+06.
    R2 = 0.9533 (a good fit for the data)
    Final value (where the trendline crosses the right-hand (secondary)

The lowest data on my chart is a 17... how do I set up the chart so that the
blank areas for 1 through, say, 15 are not shown and the chart starts at 15?

I have a time series line chart (dates on x labels, returns on Y) can I
highligh the chart in a particular date range?
THANKS!!
Stan