Free Microsoft Excel 2013 Quick Reference

pareto chart in Excel 2007?

In Excel 2003, one of the custom graph styles was a bar chart with a line and
two vertical axes. It was possible to make beautiful Pareto charts with this
type of chart, to show categories of defects in decreasing frequency of
occurrence, with a line that showed the cumulative % of defects represented
by each defect category. In Excel 2007, I cannot find any capability for a
chart with two vertical (y) axes. Can someone please help?

Post your answer or comment

comments powered by Disqus
When I hover over a line on a scatter chart in Excel 2007, I see incorrect inormation about the nearest data point.

When I hover over a line on a scatter chart in Excel 2007, I see incorrect inormation about the nearest data point.

I believe that this only occurs when I set the Min and Max scales for the chart.

If I save the workbook to 2003 format and open in Excel 2003, the data point information is correct.

Hey guys,

I'm trying to create a chart in Excel 2007 that displays a fixed range of data from a group of similar worksheets. Each worksheet contains weekly performance figures that I need to display in the chart, and the chart needs to display the past six weeks' figures so that trends can be established and any areas of concern can be raised

The problem I'm having is trying to define a fixed range of six weeks for the chart to display. The previous weeks' figures are added to each worksheet at the start of the working week, yet inserting a new row into the spreadsheet extends the data range; six weeks becomes seven, seven becomes eight etc, which is not what I would like to achieve. Short of manually redefining each data range every week, is there a way to fix the data range so that the chart only displays six rows' worth of data from the other worksheets in the workbook?

Any help would be greatly appreciated!


Currently, I cannot insert any chart in Excel 2007 even after I highlighted
the whole data table and then clicked one of the line charts. I noticed that
the chart creation could be done in my laptop with Windows Vista but not at
my home PC with Windows XP. No chart was displayed. What's wrong with the
Chart function? How to activate the Chart function?

Thank you.

In Excel 2003 I used to

1. Select a chart by shift-clicking on it (i.e. selecting without entering
editing mode)
2. Move the chart around by holding control and pressing cursor keys

This was especially useful when I needed to exactly position a chart.

In Excel 2007 I have been unable to achieve the same effect -- any



I have been trying to figure out how to make a chart in Excel 2007 and
haven't had much luck doing it a certain way. I have 6 groups (3 controls
and 3 experimental groups) each group has multiple data points. I want to
chart the average of each group in a "column graph" so that each column
represents the average of one group. I also want to have the standard error
displayed as error bars in each column. My problem is getting this to work.

So my data would look like this:

Blue Green Red Orange Yellow Maroon
1 2 3 4 5 6
1 2 3 4 5 6
1 2 3 4 5 6


Any ideas?


I have created a scatter diagram chart in Excel 2007. When I overwrite the
source data, populating the cells with new data, the chart does not update.
I have found the only way to change the chart is to delete all data series
and re-create them. Is there a better way?

I'm trying to create a mekko area chart in Excel 2007 like I do in Excel
2003. However, it appears that one can not change the X axis of an area
chart to timescale. Does anyone know how to create mekko charts in 2007?


Most Searched Demo: Create charts in Excel 2007

Charts can convey much more than numbers alone can because charts present data in a visual way that makes it easier to see the meaning behind the numbers. See how to create charts in Excel 2007.

Excel 2007 Demo: Create Charts in Excel 2007

I don't see this as a chart type option anymore in Excel 2007, any ideas how to make a Line-Column 2-axis chart in Excel 2007?

Used to be one of the "Special" or "Custom" chart type selections in Excel 2003 and earlier. Help!

Hi All,

I joined the forum yesterday.

Attached sample excel file shows data of 10 types of errors made by a team of 10 engineers as pointed out by customer. Two sample column type error graphs shown have been made using normal excel charting process.

Can someone tell me how can I make a Dynamic Interactive Error Graph / Chart in excel 2007 using Scroll or Slider commands such that by moving the Sliders or Scrolls from left to right (For Engineers) and up and down For Errors ) and without using any Macros and complicated commands all possible combinations of engineers (from Mahesh to Deepak ) and errors (Error 1 to Error 10) are covered and the chart gets updated.

Thanks and regards


hi guys,
I'm using Excel 2007..
is there any possible way to plot some line chart in Excel 2007 with Excel 2003 line style??
I mean, Exc 2007 has thick-looked line, as in Exc 2003 they looked more slight..
I want to draw a line chart with those slight line like in Exc 2003..
please help me..

I have a normal column chart in excel 2007. From another worksheet i am linking (via a text box) a percentage number to show an increase or decrease.

I want to conditional format (or via some other way) a % < 1 : to show in Red, a % > 1 to show in Green.

How can I do this automatically?



I want to use VBA to insert an Organisation Chart in Excel 2007 (ie if I did this manually it would be Insert, SmartArt, Hierarchy), but I cannot find anything on line that shows how to do this in Excel 2007. I know the code for Excel 2003, but that does not work in 2007.

Many thanks in advance for any help anyone can provide.


I posted this (gasp!) on another board but didn't get very far; hope to get lucky here.

I have some dynamic charts -- in a fairly complicated spreadsheet that I can't share online -- that become non-functional in a very strange way. I can't reliably reproduce the problem in a dummy spreadsheet so I've staged it and taken some screenshots with the hope that someone has seen this problem at some point and could suggest a solution.



So you see, the "dynamic" reference is somehow getting bashed by Excel. I'm at my wit's end trying to lick this problem and am especially frustrated by the fact that I can't repro it in a spreadsheet I can show outside of my company. Thanks in advance for your help!

Edit: I was able to find a way to reliably reproduce the problem and posted it below. FYI, a copy:

Create a SS in Excel 2007 with two worksheets. On the first sheet, enter a column of data (a few rows' worth is enough). On the other sheet, define a single-cell named range "years". Now go back to the first sheet, and define your data range calling it, say, "data" as =OFFSET($C$5,0,0,years,1) (where $C$5 is the first cell of data entered, of course). Now create a "dynamic" column chart from that data range. Save the spreadsheet. Close the file. Re-open the file and check the data source of the series. It should read "=[0]!data" instead of "=Sheet1!data".

In Excel 2003 I used to be able to select an option from the Report Filter directly on the Pivot Chart itself and the selection would show in the upper left hand corner of the chart. Now in Excel 2007 I can't get my selection for the Report Filter to show up anywhere. Any help would be greatly appreciated. Thanks.

MS has identified a problem with very slow charting in Excel 2007 for certain
conditions. A hotfix has apparently been developed to solve this problem.
Here is the link:

My question is: how do you get the hotfix? I have struggled with very very
slow charting for several months and would very much like to get it. But I
don't know how to get it without going through a paid MS support number. Any
suggestions from MS MVP's or real MS folks?



I am trying to create a dynamic line chart for my home accounts in Excel
2007 SP1.

I have data entered horizontally by month in a sheet called "Savings".

I have created named ranges as follows:

for the X axis labels:

chtsavings_label=OFFSET(Savings!$C$5,,,1,COUNTA(Sa vings!$C$5:$DQ$5))-1

This is the month title row. The -1 is because the last column is an average
which I do not want to plot

then for each account there is a row with data and I create a named range


I then try to use these values in the chart via selecting design > select data

I try to enter add under "Legend Entries (Series)" e.g.

for "series name" enter "Account 1"

for "Series values" enter =Savings!chtsavings_acct1_data

But when I press the OK button nothing happens. Excel does nothing, no error
message the only option I have is to select the cancel button.

Any ideas where I am going wrong?

There is a bug in Excel 2007 Beta 2. In the legend for the chart if the
Series Name value is set equal to a cell and that cell is hidden then the
Series Name value is not reported correctly. It shows in my case as Series2.
If I unhide the column containing the cell the correct Series Name value
appears. I can then hide the cell/column again and the chart shows the
correct value. After saving the file and opening it again the legend will
again show the incorrect value "Series2".

This spreadsheet was created in Excel03 originally.
James M

This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

I have a custom line and column chart produced in Excel 2003 but when opened
in Excel 2007 the line chart has disappeared, does Excel 2007 support this
type of chart as I cannot find any reference to this subject in the help

In Excel 2003 you could click on the line that was plotted in your XY chart
and move the data point. This would then also change the data in your table.

This does not appear to work in Excel 2007.

Any ideas?

i create a chart by copying another one (i.e. Chart 2) and chage only

next, both charts are copied and pasted special (as link to excel) into
but when i update both links, something strange happens - copied chart (in
becomes first chart.

i noticed that copied chart in excel is also named Chart 2. wtf?

i compared situation to copying charts in excel 2003 and worked normal - how
can i fix this in 2007.


What has happened to custom charts in 2007?

I used to create a chart with one data series displayed as columns
(result data) with another series on the same chart displayed as a
line (budget data). I cannot find any way of doing this in Excel 2007,
anyone offer some help on this?

In Excel 2007, click on Insert, just click on any type of chart buttons,
nothing appears. Then click on the drop-down error on any of the chart
buttons, click All Chart Types, then click any of the chart type button on
the right, click OK, the error "Some chart types cannot be combined with
other chart types. Select a different chart type." Then go to any Office
application, such as Word or Powerpoint, Insert Chart, it gives the same

I Googled, quite a lot of people are experiencing the problem, some went to
the extend of deleting the userprofile and let Windows re-create the
userprofile. However, doing that also didn't solve my problem. I tried
accounts with and without administrative priviledges, problem still there.
So, the permission problem is not the cause.

The installation of Office 2007 is fresh (meaning not from upgrade of Office
2003). Uninstallation and re-installation didn't solve the problem.

Windows is Vista Business. Office 2007 is the only application installed, of
course apart from antivirus (Microsoft Forefront), Adobe Reader and the
utilities pre-installed with Lenovo notebooks.

The symptom is consistent - New user logs in > Start Excel > In the new
blank worksheet, Insert Chart, it works and that is the only time it works >
Exit Excel > Open Excel again > In the new blank worksheet, Insert Chart,
nothing happens, Insert All Chart Types > error "Some chart types cannot be
combined with other chart....". From then on, cannot do chart. Delete the
userprofile, log in again, same series of events - only the first time and
the only time using Excel, the chart works, after that no more. It happens
to all the users who login.

I first encountered this problem one year ago, only on a Lenovo notebook

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