#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 60
Default GraphIf ?

Say if have something like this:

Col A Col B Col C
A 3 5
A 5 3
A 6 7
B 8 1
B 4 6
C 6 7
C 4 2
E 7 4

Any ideas about a function such that any A would be in plotted in one
graph, any B in another graph, and so on?

  #2   Report Post  
Posted to microsoft.public.excel.misc
dlw dlw is offline
external usenet poster
 
Posts: 510
Default GraphIf ?

use vlookup to make different ranges then plot those

"Matt" wrote:

Say if have something like this:

Col A Col B Col C
A 3 5
A 5 3
A 6 7
B 8 1
B 4 6
C 6 7
C 4 2
E 7 4

Any ideas about a function such that any A would be in plotted in one
graph, any B in another graph, and so on?


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 60
Default GraphIf ?

I'm not sure what you mean. How do you use vlookup to create ranges?

On Jan 29, 8:47 am, dlw wrote:
use vlookup to make different ranges then plot those



"Matt" wrote:
Say if have something like this:


Col A Col B Col C
A 3 5
A 5 3
A 6 7
B 8 1
B 4 6
C 6 7
C 4 2
E 7 4


Any ideas about a function such that any A would be in plotted in one
graph, any B in another graph, and so on?- Hide quoted text -- Show quoted text -


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 10:22 AM.

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"