Remember Me?

#1
November 26th 04, 07:11 AM
 Boaz Weiss Posts: n/a
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.

#2
November 26th 04, 09:33 PM
 KP, Microsoft Master Instructor Posts: n/a

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.

#3
November 27th 04, 02:17 PM
 Boaz Posts: n/a

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.

#4
November 27th 04, 02:47 PM
 KP, Microsoft Master Instructor Posts: n/a

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

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.

#5
December 3rd 04, 03:33 AM
 Jon Peltier Posts: n/a

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.

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

All times are GMT +1. The time now is 05:11 AM.