Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Any help would be appreciated...
I want to have a column graph where I show the number of customer meetings necessary before a sale is completed. I have a graph where the X axis is the number of times that a customer has been met before a sale has been completed. The Y axis is the number of clients for each number of sale meetings. Therefore it shows for example that 6 customers took 10 sales meetings, 8 customers took 7 sales meetings and 9 customers took 4 sales meetings before sale. N 12 O. 11 10 O 9 * F 8 * 7 C 6 * U 5 S 4 T 3 S. 2 1 2 3 4 5 6 7 8 9 10 NO. OF SALES MEETINGS All is fine except that I do NOT want to show values where there has been a single sales meeting resulting in a sale since this is treated differently. I have altered that data source and the graph is exactly as I want with the labels for the Y axis and the data-values on the columns. However, the labels for the X axis start at 1 and I need to start at 2 rather than 1. I cannot see how to set the X axis labels to start at 1. (It seems to be possible to do this for the Y axis in the scale option.) Any ideas please? Many thanks, Michael. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to draw chart: log scale on X axis, natural scale on y axis? | Charts and Charting in Excel | |||
How do I reference x-axis or y-axis scale values to a worksheet ce | Excel Discussion (Misc queries) | |||
How to make Primary axis and Secondary X-axis have the same scale | Excel Discussion (Misc queries) | |||
Format Axis; Scale Tab; "Value Axis Crosses At" ends with preposit | Charts and Charting in Excel | |||
How to insert X axis scale values next to axis and X axis grid lin | Charts and Charting in Excel |