Different colors on a single line chart
I have a single line chart, with dates on the X axis. After a certain date,
I would like the line to be a different color. Is this possible? Without
having to edit the color of each datapoint? And when I add new data, it
should appear in that same second color. Thanks!
To do this without code you can use 2 data series to give the appearance
of a single line.
In this previous example I posted the future data was a dotted line but
you can just change the formatting to another colour.
> Hi there
> I have a ...How to add annotation/callout/note to chart?
In Excel 2003, is there any way to add an annotation/callout/note to a
chart -- for example, if I want to add a description to a data point or
__________ Information from ESET Smart Security, version of virus signature database 5073 (20100429) __________
The message was checked by ESET Smart Security.
Open the Drawing tool (View | Toolbars)
Use one of the shapes (callouts are great) to put a shape with text on the
Caveat: you should begin by clicking on the chart to activate it then select
the shape; in...Multiple pie charts and merging them into word.
I have a worksheet that has 286 rows and I need a pie chart for each row and
then I need to have the pie charts merge for each person in Word. Is this
possible? I cannot link the pie charts to a cell so it will pull it into
Word. I don't really don't want 287 Worksheets with embedded pie charts.
Please Help! Thanks!
I have a cell with a DDE link from another program, which is sample data I
need to produce a real time graph of.
To do this I need to copy the value of the cell, A1, and paste it into B1, a
second later I need to copy the value of A1 into B2 and so on. I can then
produce a real time graph from the information in column B.
Thanks in advance.
Sorry, it should read:
I have a cell with a DDE link from another program, which is sample data I
need to produce a real time graph of.
To do this I need to copy the value of the cell, A1, and paste it into B1,
when the cell v...Auto adjust dates in a chart
I would like to build a line chart that automatically plots values for the
past 14 days, no matter when I open the chart.
I have set up a column with now() in the first cell and now()-1, now()-2,
etc. in a series for the following 13 cells down to now()-14. This column
becomes the data range for the x-axis.
If I test it by changing the system date, the now() values do not change
automatically. I know there must be a way to do that.
But the further concern is how to link values in another column with the
now()-x value to display what I want to see.
I want to use this chart to...Adding Source Data to a Chart.
I want to add data from 2 different sheets within the same work book added
together. ie say data from Sheet1 B1 + Sheet 3 B1 as source data for the same
bar on the chart. Can this be done direct or do I have to add them together
first then use that as the source data.
I have tried typically the following: Sheet1!$B$1+Sheet3!$b$1 and several
variations of this without success.
One way to do it is to have 2 series, one for each sheet, and make a Stacked
The only problem is that you don't get to see the total when adding labels
to the series.
"Dizz...20 rows but need to display only 2 at a time in a chart.
I have a chart with 20 rows and columns. I need to compare 2 rows at a time
in a simple line chart to see thier progress, for example row 1 with row 5 ,
then 4 with 10 and then 1 with 16 etc.
what would be the easiest way to achive this, for now I have to do it by
selecting the rows each time by edit data.
Can I have 2 dropdown menus above the chart with the column names so that
the chart would display the values I chose.
Thanks for your help.
It's easy to achieve this if you have a couple of combo boxes, each
referencing your list of series names/headi...Up-side down Graph
How do I make an Up-side down graph. (with y-axis values shown on the
If I understand your question...
Set your y values to negatives in the data set
set display formats as custom where negative values do not have a negative
> How do I make an Up-side down graph. (with y-axis values shown on the
> opposite direction).
...how to create line Chart with large number of data points
Operating System: Mac OS X 10.4 (Tiger)
Excel allows only some 200 data points. I would need 1025! Is there a way to achieve that or do I have to look for some other special charting software
Thanks! You are right. I found the solution.
when I add trend lines, they are invisible. however they exist....
Perhaps the color of the trendline is set to the same color as your chart
background. Look for any small breaks in the normal data curve and pass the
cursor over one of these, or otherwise just sweep the cursor around until a
pop-up indicates you are on a Trandline........then Right-click > Format
trendline > Paterns Tab > Automatic.............
Vaya con Dios,
"kyrbi" <email@example.com> wrote in message
news:uq3Yd.34730$oK.firstname.lastname@example.org....Bar Text on Gantt Chart
Is there a way to remove all text formatting from the bars at once or does
one have to format each bar individually
You can change multiple bars at once through Format > Bar Styles.
I hope this helps. Let us know how you get along.
Visit http://project.mvps.org/ for the FAQs and additional
information about Microsoft Project
On 4/14/2010 2:08 PM, Judy C wrote:
> Is there a way to remove all text formatting from the bars at once or does
> one have to format each bar individually
Text formattig on the bars is achieved through F...log axes, chart titles, Rob Bovey, loadsaprobs
In the past few days I have been building a workbook (6Mb
and growing) that contains a sheet displaying about 20
charts. I have incorporated the little trick which
references the chart title to a cell reference (very
Also downloaded the Add-in from Rob Bovey to change data
labels (as suggested by tusha mehta`s tutorial on how to
customise Excel chart log axes). I ended up not needing
When worked on, the workbook is running very slow (Excel
is using 98-99% of my processing) and appears to think a
lot before allowing access to any chart I want to edit.
Can this be the ...Pie Charts #4
In my pie chart, items are grouping together as other even though there is no
"other" in my budget -- why? It is actually a cool idea -- how to I add
other items to this "other" (e.g. very small percentages of the pie).
"IDA" <IDA@discussions.microsoft.com> wrote in message
> In my pie chart, items are grouping together as other even though there is
> "other" in my budget -- why? It is actually a cool idea -- how to I add
> other items to this "other" (e.g. very s...Including table into the chart!
A quick question.
Let us say a table with certain number of rows and columns was create
and used to plot a chart.
Is there a way we can include the above table into the chart?
I would appreciate ur help guys.
Message posted from http://www.ExcelForum.com
Make sure you have room for the table in the chart area,
select the table, hold down shift and click edit>copy picture
select picture format and paste it into the chart area.
For everyone's benefit keep the discussion in the newsgroup.
"aiyer >" <<ai...scatter chart
I am trying to chart a series of length measurements on
the X-axis plotted against a series of depths on the Y-
Axis. However, the depths are named in 5cm increments;
for example: 0-5, 5-10, 10-15., which excluded XY scatter
without modifying the desired labels. Furthermore I have
varying quantities of data for each depth range, which
excluded charting with the line charts as it is important
to maintain equal spacing between each of the axis
Currently, I have inserted a row of abitrary numbers,
representing the 5cm increments (for the Y-Axis) and have
successfully plotted...x log, y lin audio frequency chart
I'm having some trouble with limitaions in the axis display. Is there a way
to set the base number of the log graph to start at 2, or 20, and stop at
20,000 or 40,000? It always defaults to decades of one or ten.
The second issue is when I set the series by using the wizard, the data is
off(lower) by an order of magnitude for some reason that is not very obvious
Finally, what is the difference between a range and a series? I have too
many points to use the range input.
Thanks and sorry about the many questions.
I don't think it's gonna happen. When you use...Retrieving Data From a Chart
I would like to build a formula that allows me to
go back 50 records in the database to locate and list how many records
since the last time the farthest back of the 3 evaluated cells last
A51 B51 C51 (The evaluated cells)
Therefore, the result would list 9, because from the cell values
3,7,2, #2 was the furtherest back in the last 50 records.
It last occurred 9 records ago.
~~ Message posted from http://www.ExcelTip.com/
~~ View and po...Bar chart with Y Axes Categories
I have very little experience with charts, so I really appreciate your help.
I have a column of employees' "Years until retirement" (approx 139
employees). I'd like a chart that shows a bar for 0-5 years, 6-9 years,
10-14 years, 15-19 years, 20-24 years, 25-29 years and 30+.
How do I categorize to get this chart?
I think you want the categories on the X axis. In the first column of the
sheet, put your year ranges, and in the second column, put the number of
employees within each range. Make a chart from this data.
Jon Peltier, Micros...removing new data in charts
I have added new data into a chart by using a MACRO. perhaps it is not
possible to undo this using edit-undo. Is there any method to celar only
the added portion in the chart If I click the chart and click<clear> the
whole chart is removed.
thanks and regards
If you've added a new series, select the series, and press the Delete
key. If the series has been extended by adding points, select the
series, and the range with the series data is highlighted in the
underlying sheet: drag the little square corners on the colored
rectangular outlines to resize the data ranges.
-...3D Funnel Chart
Good afternoon everybody,
is there a web site and or someone that could help me in setting up,step
by step a 3D Funnel Chart?
Thank for the help
3D Funnel charts are among the worst graph types you could use. They're
based on a flawed metaphor, and this faulty metaphor makes the graph very
difficult to interpret properly. I describe the problem and offer
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech...how can I use a number series with gaps in as a chart axis
I have a spreadsheet with samples normally taken on a weekly basis. Rather
than plot the data against the week I want to plot it against a running hours
figure that is also entered onto the sheet. However if no samples have been
taken this leaves a blank and a gap in my line chart for trending and doesn't
seem to allow the running hours to be used as numbers but just sees them as a
piece of text or category. I want to see the dat against running hours at the
correct spacing of hours. I'm sure that made sense to me as I wrote it!! any
help will be appreciated
Make an XY chart.
...Multiple Stacked Bar Charts, Data Organitation
I'm building a chart that uses multiple stacked bar charts to show an
employees work time broken down into days of the week.
I've read online, and downloaded example files (funchart4)
(stackedbar.zip) and a few others. I been through this and other news
I see that the data has to be organized in a staggered format, but I'm
not seeing the connection between the way the datas arrainged, and the
way the chart determines which data goes to which bar. Currently, I
have the chart displaying two stacked bar charts for each day, but I
need to add a third stacked bar chart for eac...Area chart dives to zero when data series stops
I have a series like so:
And so on - the rest of the year is blank. When I draw an area chart for the
full 12 months the series draws an area up to April, then plummets to zero in
May. I want the area to just stop at April. My cells use the formula
=IF($A11<=$D$17,G11,NA()) therefore, the NA stops any line charts goinf
beyond April, but the area chart is more problematic.
The NA() or #N/A trick only works with charts that also accommodate a
marker, such as line, XY, and some radar charts. ...Chart Legend
I'm running Excel2002 and have created a chart using several series of XY
Scatter data. The chart is working fine, but I do not like the order in
which the various groups of source data are listed within the Chart Legend.
They don't appear to be listed either alphabetical or sequenced in relation
to the time they were created. I cannot find a control that lets me move up
or down the item listings within the legend. Is that possible? Thanks for
You can specify the order by double clicking one of the data series and
on the Series order tab change the plot order...Combine data rows in Pie Chart
I have a large excel spreadsheet that has client names and transaction
amounts on it (along with other data). I made a chart that has the
names and amount percentages on it, but there is a problem. It lists
every transaction from a client as a different piece of the pie. So if
a client has 5 transactions he has 5 pieces of the pie. Any way I can
get Excel to recognize the same name and group it on a pie chart?
Jayntree's Profile: http://www.excelforum.com/member.php?action=getinfo&us...