Has anybody got any recommendations for creating chromaticity graphs in Excel? I'm looking for a simple, configurable way to create them in Excel, using either the built-in tools or a plug-in. I don't mind buying one as long as it is resonably priced. Here's the sort of thing I'm looking to create: http://en.wikipedia.org/wiki/Image:CIExy1931_sRGB.svg

This would be for a mixed Excel 2004/2008 environment, all running under MacOS X 10.4/10.5.

This would be for a mixed Excel 2004/2008 environment, all running under MacOS X 10.4/10.5.

- Graphing In Excel
- What are the Default {RGB} colors for graphs in Excel 2011?
- Graphs in Excel Moved to PP
- How do I point out a specific date on a line graph in Excel?
- How can I make a confidence interval graph in Excel?
- Generating graph in excel
- Time graph in Excel 2010
- Graphs in excel
- Ordering graphs in Excel
- Finding the area under the curve in a graph in excel
- How do I plot non-numeric values in a graph in Excel?
- How do I create a Bell Curve Graph in Excel
- How do I point out a specific date on a line graph in Excel?
- Constructing graphs in excel
- How can i create a bridge graph in excel?
- Axis break graphing in excel
- Column graphs in excel 2004
- Draw a certain graph in excel
- Need help with a complex graph in Excel (with filter)
- Graph in Excel bounce out to Power Point.
- Derive a formula from a Graph in Excel?
- Problems in plotting graphs in excel
- Graph question in Excel 2007
- Labelling data points in Excel graph(Plz help)

I have been asked whether I can design a bar graph where the bars change colour depending on the value. (Whilst I am fairly confident in my ability with Excel, I am only new at using VB, so my apologies in advance.)

Basically, I need the following:

if the x value falls within range a (approximately the first 30% of the y axis) then the bar should be red

if the x value falls within range b (approximately the middle 40% of the y axis)then the bar should be green

if the x value falls within range c (approximately the top 30% of the y axis)then the bar should be purple

I haven't done a lot of experimenting with graphs in excel, but as far as i know there is no easy way to do this, so i wondered if anyone here would know if/how i can do this using VB.

Thanks

Megs

I don't want an approximation. I want to match what is has used in some of the automatically generated graphs elsewhere.

them onto slides in PP. 4 graphs per slide. I used to just cut & paste but

I found cut & special paste & inserting as a picture works out better for my

purpose. However, I can make graphs in Excel & check all fonts (legend, X/Y

axis) to ensure all fonts should match, for instance, all of the labels for

the axis are 10 Pt Normal, aerial; but when I paste the graphs to PP (on the

same slide) the font sizes rarely look the same. Something always looks

bolder or bigger, or more compact. The graphs on the Slide are appx the

same size so i dont think its a "this one's bigger than that one at the

destination" issue. I'm not sure if this is a PP ? or an Excel ? but I've

given up and am looking for help. I've gone to painful extremes in excel to

make sure all the data in the spreadsheet is the same size, the column & row

headings are the same font & still, the charts I move to PP do whatever they

want. I can even make 2 charts on the same spreadsheet and when I move them

to PP, the look different. I have noticed at times when copying the chart

from the worksheet, that when I click copy, the chart re-sizes it self. I'm

at a loss. Any assistance is appreciated

Kenny

specific dates without having to manually add a arrow, textbox, or line.

Ideally, I would like to be able to have a vertical line on a specific date

that would indicate before and after. Thanks.

features featurecount support

Policy 34 yes

Interface 54 no

UTM 23 yes

Bridge 56 no

Basically I am generating a column diagram with featues in X axis and featurecount in Y axis. The support column (last column) can only have values yes and no. I want the columns to be written as yes or no for the corresponding features. How is it possible to do this ?

I am attaching the generated graph from the csv file. Kindly advise on how to print the support value in the columns.

Hi, please do you know how to create this time graph in Excel 2010? Thank you

image001.jpg

image001.jpg

and then put in information from a pivot table to populate the graph with another line so i can compare that line with the standard line??

it seems that i can only have one line in my graph if i load it from the data in a pivot table??

features featurecount support

Policy 34 yes

Interface 54 no

UTM 23 yes

Bridge 56 no

Basically I am generating a column diagram with featues in X axis and featurecount in Y axis.

Excel, in general, plots the graph from top to the bottom, like from Policy, Interface,UTM,Bridge. However, I want to order the columns th the graph in decreasing order of the featurecount value, so the columns should be like Bridge,Interface,Policy,UTM

It will be of great help if anyone can provide an idea how to do so.

Assume I have the following data... :

X Axis Y Axis

A L

B M

C N

D O

E P

F Q

G R

I want such a graph

R x

Q x

P x

O x

N x

M x

L x

A B C D E F G

i.e. ABCD on the x axis and lmno on the y axis and the small x points are

the plots of AL, BM, CN etc..

I am trying to create a Bell Curve Graph in Excel but have ground to a halt,

I using Excel 9

I using Excel 9

specific dates without having to manually add a arrow, textbox, or line.

Ideally, I would like to be able to have a vertical line on a specific date

that would indicate before and after. Thanks.

Radhads

I need help drawing a certain graph in excel, but I am unsure how to draw it. I have attached the excel sheet of my result and also a sample image(drawn by someone else) on how the graph should look like. Thank you.

I am trying to build a graph in Excel dat displays the movements in interest rates. De table contains the following details:

Bank Product Interest rate Effective date

A 1 7% June 12, 2011

A 3 8% February 21, 2012

B 2 4% April 8, 2011

B 3 9% January 14, 2012

I would like this graph to display the interest rates per product (a line) and upon effective date that the line jumps to the new interest rate level). This graphs must have the possabilitites to be filtered per bank as well as per product.

My Excel knowledge isn't sufficient to pull somethign like this off. Is there someone who can help me with this?

P.s. Excel 2007.

Regards,

Sjoerd

I have created another post in reference to this, but this is probably a better idea:

Other post: [http://www.excelforum.com/excel-gene...th-excel.html]

Is it possible to create a graph in Excel and have it automatically update a powerpoint?

and ultimately I would like to create a user form in PowerPoint that will allow the account to manually override the the graph data. This is for the future but if anyone has ideas of the best way to do this that would be appreciated.

The Form Example:

Segment (Desktop/Notebook/Server)

Company (Drop down to select company only 5)

When Company is selected activate the slide based on company and segment

This section I believe may be the more difficult part:

then activate a list of boxes that can be updated representing all areas that are running out of Excel (probably not that difficult as I can just call individual cells) needing to update the graph and then upon submission graph is updated

I added the second part of this post in case someone has done something similar!

Thanks,

Jeff

I have a graph with a line. The line itself is a downward curve sloping line.

If I recreate the values from this chart, I am wondering is possible in Excel to derive the formula from this line?

Thanks for the help!

S

I have the following data:

Product Price Elastic Coefficient

$5 3.000

4 1.400

3 0.714

2 0.333

1 1.000

I need the horizontal line (product price) on a line graph to run from $1 to $5 and keep the corresponding data (elastic coefficient) in its appropriate row – since the elastic coefficient is a computed vale, I cannot simple sort on the price column as that will destroy the correct coefficient.

How can I, without typing a special column for price, get the horizontal line to run from $1 to $5.

Thanks

Indrajit.

No luck finding an answer? You could always try Google.