Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old April 25th 09, 09:06 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 44
Default Plotting data points on 2 axis

I have a table in excel

Col A: name of stores
Col B: % scores on Parameter A
Col C: % scores on Parameter B

I want to plot a chart with Parameter A on X-axis, Parameter B on Y-axis.
The stores should be plotted as data points in all 4 quadrants.

While the scores for Parameter A & B are in % (0 to 100), i want the base
point as 60%. There would thus be stores (data points) in all four quadrants
of the chart.

How can i plot such a chart. Plz help.

Regards

Nikhil

  #2   Report Post  
Old April 25th 09, 09:19 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 6,582
Default Plotting data points on 2 axis

Make an XY chart using the data in columns B and C (parameters A and B).
Format each axis scale so the other axis crosses at 60%. Not the axes cross
in the middle of the chart. Format the patterns of each axis so its labels
are in the "low" location, not Next to Axis, to move them out of the way.
You can label the points with the store names using one of these free Excel
utilities:

Rob Bovey's Chart Labeler, http://appspro.com/Utilities/ChartLabeler.htm
John Walkenbach's Chart Tools,
http://www.j-walk.com/ss/excel/files/charttools.htm

- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
Advanced Excel Conference - Training in Charting and Programming
http://peltiertech.com/Training/2009...00906ACNJ.html
_______


"Nikhil" wrote in message
...
I have a table in excel

Col A: name of stores
Col B: % scores on Parameter A
Col C: % scores on Parameter B

I want to plot a chart with Parameter A on X-axis, Parameter B on Y-axis.
The stores should be plotted as data points in all 4 quadrants.

While the scores for Parameter A & B are in % (0 to 100), i want the base
point as 60%. There would thus be stores (data points) in all four
quadrants
of the chart.

How can i plot such a chart. Plz help.

Regards

Nikhil



  #3   Report Post  
Old April 27th 09, 01:43 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 44
Default Plotting data points on 2 axis

Hi Jon,

Thanks for the response....but to be honest, i am very poor with
charts...and just do not know how to get started with selecting the chart
type and then formating the chart etc....i did try the way you suggested but
got lost... can you help me with more explicit details please

Nikhil

"Jon Peltier" wrote:

Make an XY chart using the data in columns B and C (parameters A and B).
Format each axis scale so the other axis crosses at 60%. Not the axes cross
in the middle of the chart. Format the patterns of each axis so its labels
are in the "low" location, not Next to Axis, to move them out of the way.
You can label the points with the store names using one of these free Excel
utilities:

Rob Bovey's Chart Labeler, http://appspro.com/Utilities/ChartLabeler.htm
John Walkenbach's Chart Tools,
http://www.j-walk.com/ss/excel/files/charttools.htm

- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
Advanced Excel Conference - Training in Charting and Programming
http://peltiertech.com/Training/2009...00906ACNJ.html
_______


"Nikhil" wrote in message
...
I have a table in excel

Col A: name of stores
Col B: % scores on Parameter A
Col C: % scores on Parameter B

I want to plot a chart with Parameter A on X-axis, Parameter B on Y-axis.
The stores should be plotted as data points in all 4 quadrants.

While the scores for Parameter A & B are in % (0 to 100), i want the base
point as 60%. There would thus be stores (data points) in all four
quadrants
of the chart.

How can i plot such a chart. Plz help.

Regards

Nikhil




  #4   Report Post  
Old April 27th 09, 02:03 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 44
Default Plotting data points on 2 axis

Ok...i am getting a hang of it somehow...i have a new problem...

since i intersect the axis at 60%, can i have for each quadrant the count of
data points in each quadrant?

Nikhil

"Nikhil" wrote:

Hi Jon,

Thanks for the response....but to be honest, i am very poor with
charts...and just do not know how to get started with selecting the chart
type and then formating the chart etc....i did try the way you suggested but
got lost... can you help me with more explicit details please

Nikhil

"Jon Peltier" wrote:

Make an XY chart using the data in columns B and C (parameters A and B).
Format each axis scale so the other axis crosses at 60%. Not the axes cross
in the middle of the chart. Format the patterns of each axis so its labels
are in the "low" location, not Next to Axis, to move them out of the way.
You can label the points with the store names using one of these free Excel
utilities:

Rob Bovey's Chart Labeler, http://appspro.com/Utilities/ChartLabeler.htm
John Walkenbach's Chart Tools,
http://www.j-walk.com/ss/excel/files/charttools.htm

- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
Advanced Excel Conference - Training in Charting and Programming
http://peltiertech.com/Training/2009...00906ACNJ.html
_______


"Nikhil" wrote in message
...
I have a table in excel

Col A: name of stores
Col B: % scores on Parameter A
Col C: % scores on Parameter B

I want to plot a chart with Parameter A on X-axis, Parameter B on Y-axis.
The stores should be plotted as data points in all 4 quadrants.

While the scores for Parameter A & B are in % (0 to 100), i want the base
point as 60%. There would thus be stores (data points) in all four
quadrants
of the chart.

How can i plot such a chart. Plz help.

Regards

Nikhil




  #5   Report Post  
Old April 27th 09, 05:40 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 6,582
Default Plotting data points on 2 axis

Charts don't do calculations, that's what the worksheet does. You can set up
formulas that count based on 60% or <60%.

For example, if your data is in rows 4 through 18, this formula tells you
how many points are in the top right quadrant (both 0.6):

=SUM((A$4:A$180.6)*(B$4:B$180.6))

This formula has to be array-entered: hold Ctrl and Shift while pressing
Enter.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"Nikhil" wrote in message
...
Ok...i am getting a hang of it somehow...i have a new problem...

since i intersect the axis at 60%, can i have for each quadrant the count
of
data points in each quadrant?

Nikhil

"Nikhil" wrote:

Hi Jon,

Thanks for the response....but to be honest, i am very poor with
charts...and just do not know how to get started with selecting the chart
type and then formating the chart etc....i did try the way you suggested
but
got lost... can you help me with more explicit details please

Nikhil

"Jon Peltier" wrote:

Make an XY chart using the data in columns B and C (parameters A and
B).
Format each axis scale so the other axis crosses at 60%. Not the axes
cross
in the middle of the chart. Format the patterns of each axis so its
labels
are in the "low" location, not Next to Axis, to move them out of the
way.
You can label the points with the store names using one of these free
Excel
utilities:

Rob Bovey's Chart Labeler,
http://appspro.com/Utilities/ChartLabeler.htm
John Walkenbach's Chart Tools,
http://www.j-walk.com/ss/excel/files/charttools.htm

- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
Advanced Excel Conference - Training in Charting and Programming
http://peltiertech.com/Training/2009...00906ACNJ.html
_______


"Nikhil" wrote in message
...
I have a table in excel

Col A: name of stores
Col B: % scores on Parameter A
Col C: % scores on Parameter B

I want to plot a chart with Parameter A on X-axis, Parameter B on
Y-axis.
The stores should be plotted as data points in all 4 quadrants.

While the scores for Parameter A & B are in % (0 to 100), i want the
base
point as 60%. There would thus be stores (data points) in all four
quadrants
of the chart.

How can i plot such a chart. Plz help.

Regards

Nikhil







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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Plotting 1 curve from 2 separate x-axis data Dave Charts and Charting in Excel 4 December 30th 08 12:32 AM
Not plotting data points in a line chart NameDuJour Charts and Charting in Excel 1 November 1st 07 09:29 AM
Excel Incorrectly Plotting Non-sequential Data Points [email protected] New Users to Excel 6 June 20th 07 11:29 PM
Plotting two data points as one kraway Excel Discussion (Misc queries) 1 March 12th 07 08:38 PM
plotting 'random' data on a linear x-axis tengel Charts and Charting in Excel 1 May 23rd 06 10:34 PM


All times are GMT +1. The time now is 12:27 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017