Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2
Default X-axis scale

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to draw chart: log scale on X axis, natural scale on y axis? Pratap D. chavan Charts and Charting in Excel 1 November 16th 06 08:03 AM
How do I reference x-axis or y-axis scale values to a worksheet ce retro5726 Excel Discussion (Misc queries) 0 August 10th 06 01:46 AM
How to make Primary axis and Secondary X-axis have the same scale AdamCPTD Excel Discussion (Misc queries) 0 July 14th 06 02:14 PM
Format Axis; Scale Tab; "Value Axis Crosses At" ends with preposit Pedant Charts and Charting in Excel 1 August 29th 05 03:50 AM
How to insert X axis scale values next to axis and X axis grid lin vp23larry Charts and Charting in Excel 2 June 23rd 05 03:45 PM


All times are GMT +1. The time now is 03:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"