how to get a pareto diagram in excel

I have encountered a problem with Excel 2007 recently. A scatter chart, with smooth lines, based on 2706 rows of data will print correctly, but if I expand...

In Excel 2003 it was possible to specify the range of a date axis simply by entering the minmum and maximum as dates (e.g. "1 jan 2008"). In 2007 the ...

I have multiple columns with 2008 Data. I also have another column with 2007 Data. Instead of creating a bar chart with one bar for 2008 and one bar for...

I have created a worksheet and formattted it according to our textbook in class. i am up to the point of inserting a chart, but when i go on the ribbon to...

Trying to paste an Excel 2007 chart into Powerpoint 2007. If I paste as a graphic, the resolution is too low to read chart text. If I do a default paste...

Hello, Is there a way to pick up (in my x-axis labels) the conditional formatting from my data table? I have a simple dashboard of project statuses and I...

I have two sets of arrays. Array one contains a column of time values with a fixed interval. Array two contains a column of time values with random...

Excel 2007 I can't for the life of me find this again I have a bar (column) chart with 3 data sources. They are now side by side for each record. I want them...

I have a stacked bar chart that I would like to add percent labels to. When I click on the chart options and go to the data labels tab, the 'percentage' box...

I often plot measured data as a scatter plot with the value on the Y-axis, and a time or date on the X-axis. The wizard will pick default values for the...

I have an existing stacked bar chart with the left Y-axis as the bar amounts combined with a line with the line amounts displayed on the right Y-axis. I...

In previous versions of Excel I was able to color code a series of data in a scatter plot based on another colum of data (i.e. cross plot column 1 versus 2...

I am putting together charts that displays weekly data for last year and this year but I want the x-axis only to display months while the weekly data points...

i can put the % next to the text by the graph, but I was hoping to put it on the legend next to the color followed by the description. Is this possible?

I've read through many of the items here looking for a solution to my problem, but have had no luck yet. Here's what I'm trying to do: I've created a Pie...

Hi, I have a chart that is based off of a pivot table. I would like to have a date range button on my chart. When the user selects the date range, I want...

How to create an ongoing addition of numbers in an excell chart. Or sum of Numbers I should Say. I need the info for work. I think there is an easier way...

My secondary axis value is say 10% and the mouse-over value displays .10 which is incorrect, can you advise how to fix this please

I have values in the first colum from 1895-2008 (for x axis) and values for y axis startign at 1 up to 2500 How can I create a line graph to show...