I have a bar graph and woulld like to have one of the bars change colour depending on the value of a cell (1 - Green, 2 - Orange, 3 - Red). I dont have a lot...

Hi there, I'm trying to create charts, where the y-data for each chart is a different row, but the x-data is fixed. I'd like to create an x-y scatter chart...

Hi, I'm currently struggling to change the Title and the Legend of pie charts that are generated by passing data from Word to Excel, then copying the chart...

Hello, My problem is clearly stated in the example below... Example: I have 50 failure codes that have occurred throughout the fiscal year, but only 5 to 7 of...

How do I insert a break in a line graph in excel? Is it even possible??

Does anyone know of a free Excel add-in that will allow me to create a map from some data that I've entered?

I want to populate cell A1 with specific text (the word "Active") whenever the word "Yes" is found in cells A2:A20. Whenever the word "Yes" is not found in...

I've been reading Edward Tufte's "The Visual Display of Quantitative Information" (which, by the way, I can whole heartedly recommend to anyone with a...

I've recently created an Excel spreadsheet to track Utility (water, sewer, electricity) consumption and costs at 5 different locations...tracking the past 3...

I have Dates on the X-axis of a chart. I would like the markers or ticks to be the actually dates. But the way it is now it has the major unit as 7 so it is...

When creating a stacked bar chart we use different colors from light to dark. The legend appears as dark to light. How do I reverse this without changing the...

I'm trying to find the area between two lines in a line chart. Both of the lines are non functions so I am unable to intergrate. How can I find the...

We are preparing a bubble chart in which the x-axis shows scores from a survey, the y-axis shows relative importance, and the z-dimension shows the percentage...

I have a spreadsheet which I record fortnightly data in. When I create a chart, the chart is picking up the days in between the fortnight dates and messing up...

I'm trying answer a survey in an excel sheet and everytime I try to type in an answer a message comes up saying I need to remove protection.When I head up to...

Hi The charts/graph-making utilities that come as standard with ms Excel (2003) are driving me nuts! Can anyone recommend anything better that is dirt...

Hi! I have a table which has mainly values between 0 and 5000 and I made bar chart from that data. Then I have 1 value which is over 100 000. This ofcourse...

Has anyone drawn SPC Chart in Microsoft Excel?

Can anyone recommend a procedure for creating large format scaled charts? Ideally, I'd like the y-axis to have a scale of 5 inches per unit and an x-axis of 1...

I have table like...