Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Boaz Weiss
 
Posts: n/a
Default How to build a chart with 2 values per item?

My problem: In my sales forecast in Excel I want to give 2 values for each
customer : Importance (1-5) and Easiness (1-5), and then to plot a graph with
all the customers. The graph should look like a matrix 1-5.
Please advise to
  #2   Report Post  
KP, Microsoft Master Instructor
 
Posts: n/a
Default

Plot the first set of data on the X axis and the second set of data on the Y
axis. Thus, you need to configure your data source in seperate rows as
follows:

Importance: value 1-5
Easiness: value 1-5



"Boaz Weiss" wrote:

My problem: In my sales forecast in Excel I want to give 2 values for each
customer : Importance (1-5) and Easiness (1-5), and then to plot a graph with
all the customers. The graph should look like a matrix 1-5.
Please advise to

  #3   Report Post  
Boaz
 
Posts: n/a
Default

Very poor answer. i need to attach data labels to the XY Chart. Is there a XY
Labeler in the Excel ?

"KP, Microsoft Master Instructor" wrote:

Plot the first set of data on the X axis and the second set of data on the Y
axis. Thus, you need to configure your data source in seperate rows as
follows:

Importance: value 1-5
Easiness: value 1-5



"Boaz Weiss" wrote:

My problem: In my sales forecast in Excel I want to give 2 values for each
customer : Importance (1-5) and Easiness (1-5), and then to plot a graph with
all the customers. The graph should look like a matrix 1-5.
Please advise to

  #4   Report Post  
KP, Microsoft Master Instructor
 
Posts: n/a
Default

Correction...the problem lies in your CRYPTIC description to your problem.

Charts are based on SOURCE DATA. Thus your source data row/column headings
will DETERMINE your chart's data labels.

NAME YOUR COLUMN AND ROW HEADINGS ACCORDINGLY TO REFLECT YOUR CHART'S DATA
LABELS.


"Boaz" wrote:

Very poor answer. i need to attach data labels to the XY Chart. Is there a XY
Labeler in the Excel ?

"KP, Microsoft Master Instructor" wrote:

Plot the first set of data on the X axis and the second set of data on the Y
axis. Thus, you need to configure your data source in seperate rows as
follows:

Importance: value 1-5
Easiness: value 1-5



"Boaz Weiss" wrote:

My problem: In my sales forecast in Excel I want to give 2 values for each
customer : Importance (1-5) and Easiness (1-5), and then to plot a graph with
all the customers. The graph should look like a matrix 1-5.
Please advise to

  #5   Report Post  
Jon Peltier
 
Posts: n/a
Default

To label points in a chart, download and install one of these free addins:

Rob Bovey's Chart Labeler, http://appspro.com
John Walkenbach's Chart Tools, http://j-walk.com

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Boaz wrote:

Very poor answer. i need to attach data labels to the XY Chart. Is there a XY
Labeler in the Excel ?

"KP, Microsoft Master Instructor" wrote:


Plot the first set of data on the X axis and the second set of data on the Y
axis. Thus, you need to configure your data source in seperate rows as
follows:

Importance: value 1-5
Easiness: value 1-5



"Boaz Weiss" wrote:


My problem: In my sales forecast in Excel I want to give 2 values for each
customer : Importance (1-5) and Easiness (1-5), and then to plot a graph with
all the customers. The graph should look like a matrix 1-5.
Please advise to


Reply
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



All times are GMT +1. The time now is 09:29 PM.

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

About Us

"It's about Microsoft Excel"