|
Help on Stacked column graph
Hi,
with the following group of data
1 2 3 4
a 10 10 30 5
b 30 5 32 42
c 10 12 15 28
I want to have a graph with 2 column s for each letter, one with the value
of column 1 and another one with the sum of columns 2, 3 & 4 with different
color for each value.
I've seen that is possible in some built in graph but not sure how to make it
Thanks
--
Alvaro...
|
2 |
11/8/2008 11:03:20 PM |
|
|
Conditional formatting in a bar chart
I have a horizontal bar chart for weekly sales figures i.e. this years
sales minus last years sales .
I am using Excel 2007.
I have positive and negative sales figures.
Everything works fine but I would like to chart negative sales as red and
positive sales as green on the same chart?
I am new to Excel and I am not comfortable using VBA code, if that helps.
Thanks
...
|
5 |
11/8/2008 5:06:06 PM |
|
|
Excel 2007 Line Graph, Data Table, Number Formatting
I'm using Excel 2007, and have created a Line Graph with a Data Table below
the graph. The issue is that the Number Formatting is fine with numbers like
2.53 and 2.58, but the number formatting shows the number of 2.50 as 2.5. It
cuts off the trailing zero for this and only this number in the table. The
source data says "2.50", and all other numbers show two digits to the right
of the...
|
6 |
11/8/2008 4:13:10 PM |
|
|
Worksheet cell info to chart
After the line chart gets its info, I have to edit the header each time to
show the correct product number. Can it be done so that say B1 has 1148, I
would it to show at the top of the line chart automatically?
Could I also choose the font size?
TIA
...
|
3 |
11/8/2008 6:43:00 AM |
|
|
macro in chart loses focus
I have four dashbards each with 4 charts containing macros, and each in it's
own workbook. The data for the macros is all in the same workbook. It works
fine.
This morning I had a request to create a table of contents so that the user
could click a button and open a dashboard. I crated this in a separate
workbook. It includes buttons with macros so, if the user clicked on army,
for e...
|
12 |
11/8/2008 5:25:43 AM |
|
|
Auto color scheme is in an Excel chart
I am looking to find what the auto color scheme is in an Excel chart.
Basically, when you select a range of data for a chart it
automatically selects a color for each line in a line graph. I, for
the sake of formatting and conditional formatting, need to know what
that order is for the first 40 colors.
I am currently using Excel 2003.
Thank you....
|
5 |
11/8/2008 5:24:47 AM |
|
|
preserve sizing of pivot chart buttons
I have a front end with 4 embedded pivot charts. Each chart has macros take
the user to select different categories, then go into the table of the pivot
report. However, when to do, the macro buttons are resized because the chart
changes and is resized. In addition, when they select a category, the chart
title pops up, and also moves the pivot table buttons.
I tried adding protection, but...
|
2 |
11/7/2008 9:56:00 PM |
|
|
Chart doesn't print w/worksheet but will print by itself
Hi
I'm using excel 2003, I have a worksheet with a bar chart located within the
worksheet. If I print the entire worksheet the chart doesn't print
correctly, it will only print a small portion of the text boxes that I put on
it. If I click on the chart itself and print it's fine. Here's what I've
tried so far:
- selected the chart area and then chose "move to front"
- made sure the p...
|
3 |
11/7/2008 6:19:00 PM |
|
|
Fix a comment to a moving datum point in a line chart
I have a chart which tracks 13 weeks of data. Each week the data in the
table is moved one cell to the left (Copy the right 12 columns and paste
special over the left 12 columns) and add the new weeks data to the very
right column. I have data labels (value) on the points in the chart.
I need to add a comment to a datum point and have this comment move across
the chart from right to lef...
|
2 |
11/7/2008 4:10:11 PM |
|
|
Pivot table question
Thanks for any help.
I want to make a pivot table on 2 fields. The y-axis has the "birth year"
(ie 1990), and the x-axis has the "years of life" (ie 4). The inner data is
the number of people/records/etc alive born at that year, that many years in.
I would like the pivot table to sum the number of records (this pivot table
is based on a query which has the birth years and years of life) f...
|
2 |
11/7/2008 4:05:01 PM |
|
|
Help! I am asked to create a graph in a Time format (00:00:00).
My supervisor asked me to create a graph in time format (00:00:00). Can
anybody help me? I have not a chart for this format and I cannot seem to do
it.
Thanks.
Tess Neumann...
|
2 |
11/7/2008 3:29:03 PM |
|
|
Want to create a separate PDF file for each of multiple charts
I create charts from excel data and want to save each chart in a separate PDF
file or to separate files using "print to file". Presently they all print to
a printer. ...
|
2 |
11/6/2008 10:14:02 PM |
|
|
2 colors in one line
Hi there I am putting a chart together to show the performance trend for
Budget, Actual and Forecast
Budget will not change therefore will be one color
However, I would like to combined the Actual and Forecast together. So i
have the actual dor every months to current month and all future months are
figures from forecast.
I have created a table for the graph data and the user toggles...
|
3 |
11/6/2008 1:16:19 PM |
|
|
How do I copy a pie chart (just the circular pie) into powerpoint
I need to copy the circular pies into a powerpoint document (to place on top
of a map) - I can't figure out how to do it without copying the whole chart
(ie the square box surround it with the legend and title - I've deleted these
but don't know how to seperate it from the pie)
Can anyone help??...
|
1 |
11/6/2008 10:16:00 AM |
|
|
t-test for paired means
im using day customers purchases and evening customer purchases and i want to
determine if evening customers puchase, on average, more than day customers..
i did a t test two tail but i just need to clarify what the numbers actually
mean and how they can help me>?? can anybody help??????...
|
2 |
11/6/2008 12:13:03 AM |
|
|
2007 Chart font
How do I change the font for the header of the Data Table? Its set up so on
the axis on the left it says 2006, 2007, and 2008. The axis along the top has
17, 22, 50. The boxes have the total number of times 17 22 and 50 were used
in each year. I would like to change the font for the 17, 22, and 50 since
its the same size as the number of times they were used, and doesn't stand
out at all...
|
1 |
11/6/2008 12:01:01 AM |
|
|
sorting a pie chart
I have a pie chart that I would like sorted graphically in descending order.
When I sort the source data, it still doesn't sort on the chart....
|
1 |
11/5/2008 9:48:07 PM |
|
|
Graph Monthly Perfomance with change to plan mid-year
How do I set up an Excel spreadsheet that charts (in a line graph) three
separate data series when each set has a different range. I'm trying to
chart fiscal year performance (updated monthly) showing original mothly plan,
revised plan (beginning in June) and the monthly actuals.
thanks...
|
1 |
11/5/2008 7:47:02 PM |
|
|
add break even point
I need to add a break even point in my line chart, I have positive and
negative values. ...
|
2 |
11/5/2008 6:33:05 PM |
|
|
How do I chart something with some missing data?
I've been tracking the status of our grant money in one of our databases. I
try to track this each day, but sometimes I miss tracking it one or two days
at a time. Anyway, I would like to chart the draw down rate of this fund,
but as you can see I don't always have a value for each day. How do I do
this for days that I'm missing?...
|
2 |
11/5/2008 4:07:11 PM |
|
|
chart markers
Can I copy the series marker and marker fill color from one chart to another
without making a template? I have many charts with series already selected
and do not want to manually change the marker and fill colors.
Thanks...
|
2 |
11/5/2008 2:21:02 PM |
|
|
Change the Point of a Series
Using Excel 2000
I have a column chart for the status of work requests. There are 2 columns,
Open and Closed with Open displayed to the left of closed. I added a new
Series to this chart for Overdue requests which I can display on top of my
Open column to show how many of my open are Overdue. I am trying to add
another Series called On Time to show how many of my closed were closed on
t...
|
1 |
11/5/2008 12:58:07 PM |
|
|
Excel Chart Problem!!! (Bug I think)
This is a multi-part message in MIME format.
------=_NextPart_000_00B9_01C93A2D.3C166610
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Try the folloing.
1. Open Excel.
2. Paste the following data
A B C D E F=20
2008 10 20 30 40 0 10=20
3. Menu Insert/Pie (select the first Pie type)
4. Right Click one of the top of any pa...
|
3 |
11/5/2008 11:26:12 AM |
|
|
Time formula
I'm trying to find a fomula that inserts the time on column b when I enter a
text on column a....
...
|
1 |
11/5/2008 4:57:00 AM |
|
|
Live Preview with Charts
Why doesn't Live Preview work with charts in Excel?...
|
1 |
11/4/2008 10:44:01 PM |