how do i create a pie chart for a survey analysis?
i do not know how to enter data in the worksheet?
...create chart from non adjacent range
I need to know how to do this
Select one area, then hold CTRL while selecting the next area, etc. Then run
the Chart Wizard as usual.
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
"rita" <email@example.com> wrote in message
>I need to know how to do this
I am using Office 2007 Beta 2 version and I am having problems with
Excel. I am unable to copy a sheet with a chart in it. Below is the
1. Create new book
2. right-click sheet 1 tab
3. Insert , then insert a chart
4. right-click chart 1 tab
5. choose move or copy...
6. copy chart 1 to the end of this work book.
I cannot create a copy of the chart. Is this considered a bug in Excel
2007? If it is, do you know any links to sites that I may use as
Lots of bugs in Beta 2 especially with charts, I'm told
If its any consolation, I cannot copy a chart ...Pictures in Charts
I am using pictures as fill in my Excel charts. The problem I am having is that after I "Select" the picture in in the Fill Effects - Picture tab, the other options are not available. Ex: Format - Stretch and especially the Apply to - Sides - Front - End. I want the picture to be one continuous image and right now it is replicated on the sides
Without sending me code - obviously, I am not at that skill level - can anyone tell me how to fix my problem
Thanks in advance
Also if someone would answer Jen regarding the spot color in Excel - I would be really interested in that mysel...Change background / color of chart worksheet?
Need steps to change the color or backgound of the worksheet that is a chart.
Have multiple tabs in workbook that are just the charts. Only option for
background is to use Format-Sheet-Background. That changes background of
chart, but not the grey areas around the chart on the chart tab.
You need to select the Chart Area (what you call the, "grey areas around the
chart") and format that.
There are 2 separate, "parts" to a chart:-
1. The Plot Area (which you seem to have formatted OK) and the
2. Chart Area.
You need to select each of them to format th...Stacked/clustered column chart with a two vertical axes
Much has been discussed here about how to build this chart, but I
haven't found anything explaining the possibility of combining it
a second y axis. I want to graph the advertising expenditure and
rating points (what would be the return of investment on advertising)
on television for three diaper brands by day part. Day parts would be
represented by the different colors of which columns will consist.
There are 5 of them: day, early, prime, late and over. For each
I want that two data columns show. The one to the right will represent
expenditure in $ and the one to the...Chart won't show zero percent
I am doing a pie chart using a quick style design that shows the lines in
between the different percentages. Some of the charts show a percentage with
the lines when the value is zero and two of my charts erase all but one of
the lines when a zero is placed in one of the cells. What's up with that?
and How do I correct it?
Since with zero value the lines of the pie would be on top of each other, I
am not sure what one would expect to see!
Bernard V Liengme
Microsoft Excel MVP
remove caps from email
"PURVIANCE" <PURVIANCE...Charting with zeros or DIV/0 values
Hi - this might have an easy solution, but I'm a bit stuck.
I've created a spreadsheet for data entry by another party. This data
will be entered on a monthly basis and I only want to update it
occasionally. So, I have control charts set up with the basic formulae
(percent, mean, upper and lower control limits) in there. I was
wondering if there was any way to have all of this data in the range of
the chart without having the chart bottom out (i.e. plotting zeros).
For example, my columns _might_ look something like this:
Date.........Total...Defects...%ofDefects...Mean....UCL....Formatting all data series in a chart
Operating System: Mac OS X 10.5 (Leopard)
If I, for example, want to add value labels to all series in a chart (or change line width or anything else that normally would be similar for all series in a chart), I have to select each one and make the change for each of them. <br><br>Is there a way to target all data series at once? (I would expect shift-click or cmd-click to select multiple series, but that doesn't work.)
...Color Break in Line Charts?
I have a cash projection spreadsheet with a linked line chart. In the
projection sheet, the font goes from black to green when the data goes from
actual to projected.
Is there a way to make the line or the x-axis change colors at the point
that the date does so (i.e., have the line turn green halfway through the
Thank you in advance.
On Oct 23, 8:39=A0am, Mr. Platypus
> I have a cash projection spreadsheet with a linked line chart. =A0In the
> projection sheet, the font goes from black to green when the data goes fr=
om...Using offset in series values of a chart
I have 1 named range created with the offset function on sheet(1):
Simple to use as the x-as categories in a chart.
For the y-axis I want to use data which can be offset 1, 2, up to 20 columns.
Yes I can create 20 named ranges but to do that for 20 sheets in my workbook
Therefor my question:
Can I use the offset function in the series values, like:
In VBA it it can be done with:
..SeriesCollection(2).Values = Month.Offset(0, 17)
But then I have to create one macro for each graph...again cumbersome.
T...How can I place the legend next to the data point on a chart?
In Excel 2003 there was an place the legend next to a data point. I just
upgraded to Office 2007 and can not find this option.
Select the data labels and right click. Format Data Labels to bring up the
Select Label Options in the list.
The 3rd section has the checkbox 'Include legend key in label'
Andy Pope, Microsoft MVP - Excel
"LW52" <LW52@discussions.microsoft.com> wrote in message
> In Excel 2003 there was an place the legend next to ...How do you control the color/pattern of a pie chart?
I need help with my pie charts. I need to create pie charts that are easily
understood in B&W. How do I set the color or pattern for each portion of my
To format a slice you need to select it first. Click the pie once to
select all slices. Click again to select individual slice.
You can use the Fill Effects > Patterns to fill with b/w patterns.
Also in print preview the Setup dialog has a Print Black & White option
on the Chart Tab. Note this is only visible if you have a chart sheet or
select the chartobject before print preview.
If you are printing chartobje...Charting problem
I have a range of cells (2 columns, say A2:B200), this is my plottin
range. But when the data is added I want the chart to adjust itself t
include new data in plot range. Is there any method I can do this?
Message posted from http://www.ExcelForum.com
> Hello All,
> I have a range of cells (2 columns, say A2:B200), this...Bar Chart #6
I have a bar chart with different percentages displayed as the columns. Or
target is 70%. Is it possible to have a target line added to the bar chart to
show how many meet the target?
In a line graph I just add a target column to create the target line but
this will not work with a bar chart
Any help greatly appreciated
opps forgot to say using Excel 2003
> Hi All
> I have a bar chart with different percentages displayed as the columns. Or
> target is 70%. Is it possible to have a target line added to the bar cha...Automatic Dynamic Chart Ranges
I have an XY plot that refers to a set range of values on my worksheet
In this case, it is 8 rows long. I chose 8 rows because that is th
maximum number of data points that I will ever need. I have set up th
chart values so that they are dynamically calculated based on VLOOKUP
from other data. Sometimes there are only 2 data points, sometimes
or 6. The problem is that no matter how I set up the formulas, Exce
does not like the cells without values in them being included in th
chart series (I have hardwired it to include all 8 rows). I thought i
might ignore a blank ("" in ...Sending Chart as Snapshot Format
How I can send pivot chart as Snapshot Format? Or how I can send pivot chart
by email ( I use send object in macro) but when I select form then there was
not output format as Snapshot what should I do?
Message posted via http://www.accessmonster.com
You might also try printing to a PDF. There are several free PDF creators
and one excellent inexpensive program, Win2PDF:
Arvin Meyer, MCP, MVP
"Reza via AccessMonster.com" <u2845...Charts Line Types for Multiple Data Series not Printing Properly
Hi, I would appreciate any advice anyone has on this printing problem I am
having with data series line types. I have a bunch of charts that each have
5 data series on them (lines) Some are solid line types and others are either
dotted or dashed so you can differentiate when printed in black and white.
The problem is when I print they are all coming out as solid lines. The dots
and the dashes are not spaced enough apart so they come out as one solid
line. I have double check that I do in fact have the proper line type
selected. I am using Excel 2000
...Display web chart in excel
I am trying to create a financial spread sheet and link a chart from ADVFN so
it shows up live in my spreadsheet. Havent got a clue how to make this work,
any ideas would be appreciated.
I may not be understanding what you're after...
(and I don't know what ADVFN is) but,
have you tried inserting a hyperlink from the menu?
Select which cell you want the link to show, then
Insert->Hyperlink... and complete the information
(link address, name, screen tip, etc)
Or are you looking for something more??
>I am trying to cre...Side by side stacked bar chart
Is it possible to do a chart that has side by side stacked bars for different
periods? For example, I want to compare quarterly profits for the years 2004
and 2005. I am using MS Excel 2003.
See Jon Peltier's page on cluster stacked column chart.
> Is it possible to do a chart that has side by side stacked bars for different
> periods? For example, I want to compare quarterly profits for the years 2004
> and 2005. I am using MS Excel 2003.
Andy Pope, Microsoft MVP - Excel
http://...Using a named range as a data source for a chart
I'm trying to build a chart that that has a named range as its data source.
The named range refers to a table that is 2x3 and is called geographydata. Is
there any way that I can have the source data for the graph to be
You can enter the name, preceded by the worksheet name and exclamation
point, for the data range, but Excel will convert this name to its cell
address. If you want the chart to be dynamic as the name changes its size,
you have to define a name for each series' data. This will not dynamically
change the number of series in the ch...Selecting data for charts by criteria
I am in control of a large database of information and I want to be
able to automatically make my charts update to include new data that is
added. I am using a regular excel spreadsheet. I would also like to
be able to select which data is used for a chart depending on a
criteria such as, 0 <= value <= 10.
Any help is appreciated.
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/
If it's an external database, I guess yo...can you create a dynamic chart in an xlt templet
I have set up a dynamic chart using the Defined Name
=OFFSET(Template!$C$#,,,COUNTA(Template!$C$3:$C$20000),1) Named datalabel,
and Defined Name =OFFSET(datalabel,0,1) Named data. These named ranges where
saved in chart1.xls and worked fine. However, When I re-created the same
Defined Names in chart 2.xlt and tried use them in a chart, a message
returned Referrence not valid, Work book must be open? chart2.xlt was open?
Is 'Template' the name of the worksheet or the workbook? If the former, it
should work -- I just verified it. If the latter, change your workbook so
that ...Ogive Chart
I have an assignment to produce an Ogive chart from a series of data. Apart from never hearing of an Ogive before, do you know if Excel can perform this function?
It transpires that an Ogive chart is a greater than and less than chart, but this doesnt really help me much!
Any assistance is greatly appreciated.
> I have an assignment to produce an Ogive chart from a series of data.
Apart from never hearing of an Ogive before, do you know if Excel can
perform this function? It transpires that an Ogive chart is a greater than
and less than chart, but this doesnt really help me mu...location of chart
The option to have the chart on the same sheet is not available. Why not?
will need more information to even have a guess.
> The option to have the chart on the same sheet is not available. Why not?
Is the sheet/workbook structure protected?
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
In article <9A832669-4C00-40CE-A265-E4A9772CF20B@microsoft.com>,
> The option to have the chart on the same sheet is not available. Why no...