show another column when hovering on a point in a chart
Is it possible to show another column when you hover on a point?
I have 3 columns, A, B, and C for a scatter plot
I have B and C as x and y coordinates of a point,
and I'd like to have Excel show A when I hover on the point.
...Has Anyone ever seen a chart like this?
Looking for some help. I need to know what this column chart is called?
Or how to make it?
'CLick Here to View Chart'
I can't find any option in Excel to make this chart. Maybe it was not
made in Excel? Or I need a specific plugin?
TsunamiBob's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=36202
View this thread: http://www.excelforum.com/showthread.php?threadid=559874
Formula or VBA?
I am trying to create a formula to assign a region to populate a chart. I
know there is a way to use the OFFSET function to point ot a certain section
of a data sheet, but what if i insert a line between the title and the
data.(done programmactically)? the problem is that inserted lines do not
automatically include into the data range for a chart.
The data wants to be sorted from newest to oldest. Would it be easier to
create a formula to assign a 'chart data area' or simply reassign the data
area every time the table is updated
Thanks for the input.
...chart label reference based on the column number
In a worksheet with an embedded chart, I have a cell, S4, where I enter the
number of the column I want to chart (these numbers are listed as labels in
I can't figure out how to translate the number in S4 into the corresponding
column letter. For example, if S4 contains "3", the chart title should be
I think working with absolute references, R1C1, might be easier here, but
somehow what I've tried, didn't work (the entire spreadsheet is based on
relative addresses (A1).
in a cell (Z100) put
Change G2 to whatev...DEADLINE... PLEASE HELP! Stacked Bar chart?
I'm not even sure how to ask the question so here's what I have...
2003 2004 2005
Actual/Goal Actual/Goal Actual/Goal
Me 1009/1061 591/866 658/897
Comp. A 966/1012 633/811 624/808
Comp. B 699/744 450/593 480/607
Comp. C 957/1005 642/821 665/838
I wanto to show a bar for each competitor, for each year, so there will be 4
bars for each year. Each bar showing Actual performance & Performance Goal...Core Chart
Need a picture of an opened sphere showing core and layers.
Can you help?
After managing to set up OE-QuoteFix on his new PC, Ed reads a message
from Isabel <firstname.lastname@example.org>...
> Need a picture of an opened sphere showing core and layers.
a) The core of what? A black hole? An apple? A nuclear power plant?
b) This is a Microsoft Publisher group. Your question is hardly relavent to
the topic of discussion really. Why did you choose this group?
Ed Bennett - MVP Microsoft Publisher
Before reading this message, view the disclaimer...Color Tabs
Is there away to change the color of the tab only when the sheet is
Only from XL2002 on.
"zero" <email@example.com> wrote in message
> Is there away to change the color of the tab only when the sheet is
Only in 2002/2003 Zero
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
"zero" <firstname.lastname@example.org> wrote in message news:email@example.com...
> Is there away to change the color of the tab only when the sheet is
> active...z-order of various lines and bars in an Excel 2007 chart
What is the procedure for changing the z-order of various lines and
bars in an Excel 2007 chart, such as drop lines, high-low lines, up/
down bars, and error bars?
I observed that when I add drop lines to an Excel 2007 chart, they
appear in front of the underlying data -- in my case, the underlying
data is displayed as a plotted area. I want the plotted area to be
fully visible with no lines over it.
I would like to send the drop lines to the back and keep the plotted
area in the front, but there is no option to do this.
So, is there a procedure for adjusting the z-order of drop...Hierarchy Pyramid Chart
Is there a way (Excel 02), to create a chart that is in the shape of a
pyramid/triange (i.e. like a pie graph, but in a triangle instead)???
It doesn't seem to be an option, but maybe some type of addin???
Thanks in advance
Nevermind - I realized that the pyramid is actually a diagram. So I inserted
a Diagram - Organizational Chart instead and it's just what I needed!!!
"Keep It Simple Stupid" wrote:
> Is there a way (Excel 02), to create a chart that is in the shape of a
> pyramid/triange (i.e. like a pie graph, but in a triangle instead)???
> It doesn't ...Locking cell color while allowing data changes in cell
In excel 2000, I created an attendance worksheet for my
classes.(Alphabetized names down left vertical column. Dates across
top of horizontal row.) I added a different color to all cells in
every other row to make for easier reading of each student's name and
absences. Every other row stays with a white background.
My question: I wondered if it was possible to lock row colors while
allowing data to change on top of them. If a new student is added to
my class in alphabetical order, the alternating color pattern is often
lost. It is a pain to rechange row and cell colors.
Any shortcut ...How do I lock a chart so it will not update?
That's the question. I have my data in Excel and the chart in Excel but not
all the data cells are used. Everytimg I open the chart it wants to update
and I want it to stay the same.
Any ideas on how to lock the chart?
Just a few ideas:
You could lock the cells that are shown in the chart.
Or you could copy the cells and paste as values (assuming formulas were used
that update when other cells change).
http://www.wimgielis.be = Excel/VBA, soccer and music
"Locking a Chart" wrote:
> That's the question. I have my data in Excel and the chart in ...excel fillin color
Fill-in color does not show on worksheet while working on the sheet only in
the preview Have I turned off a switch or what needs to be done?
The high contrast setting may be turned on. There's information in the
following MSKB article:
OFF: Changes to Fill Colour and Fill Pattern Are Not Displayed
"ron" <firstname.lastname@example.org> schrieb im Newsbeitrag
> Fill-in color does not show on worksheet while working on the sheet
> the pr...How can I reset the default pie chart label "Other" to "Equity"?
I show Cash, Equities, and Fixed Income in the large pie to the left. The
equity slice is further split into large, medium, and small. The problem is
that the Equity slice gets relabeled as "Other". When I manuallly change it
back to Equity, I lose the ability to link to any new data...so I can't use
the pie chart as a template that would allow me to put new data in the table
and have the pie chart adjust automaticially. How can I reset the default
pie chart label to "Equity"? or is there another solution.
Instead of making pie charts (which are notor...Chart Wizard #5
Does excel 2007 have a chart wizard? If so, how do I access it?
The chart wizard no longer exists in Excel 2007, RIP. You create a chart
using the various chart buttons on the Insert tab, then struggle through the
three Chart Tools contextual tabs looking for the controls to set up the
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
"Liberty" <Liberty @discussions.microsoft.com> wrote in message
> Does excel...Easy dynamic chart.
Creating a dynamic chart is difficult, there should be a dynamic chart wizard
that will create it with you.
Also if my serie value is a name range, it would be nice to just right the
Name range directly not with the complex formula.
but just name range.
xyz and name range is a fictive value.
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...Drawing static/edit control in different colors
This should be a simple question, but it is possible to, control the color
of text written to static text or an edit box? I need to do this at during
InitDialog and while dialog is 'up' (DoModal).
As an aside, can change the color of static text just based on the resource
ID? i.e. not creating a variable for the control in the dialog class.
Thanks in Advance!
Corey Wirun wrote:
> Hi All,
> This should be a simple question, but it is possible to, control the color
> of text written to static text or an edit box? I need to do this at during
> In...Custumize Chart Tittle Description
How can I make the Chart Tittle to be equal to a specific cell located in one
sheet. For example, I have a description on the cell "D10" located in the
sheetname "Black" . I want this description to be the Chart Tittle because is
a number that will change in the daily basic.
I have been using this formula "=Black!D10"; however, is not working.
Thanks in advance.
Click on the title, type =, and then click on D10 on Black.
Or click on the title, and type =Black!$D$10
Powered by Creative Laziness
> How can I...My charts do not show when moved as a separate chart tab...
In excel 2007 my charts are displayed when inserted in a a sheet but they do
not show when moved as separate tabs
...How do I set an auto alternating row color?
I'd like to set my excel database ROWS to alternating colors(ex. teal &
white). My database is HUGE and I can't feasibly do it manually without
taking hours and hours clicking each row and changing the color. Also another
concern is that I constantly am adding rows throughout the database. I'd like
to know if there's a way to automatically have to row colors stay alternating.
Thanks a ton!
Select all your cell, the use Format / Conditional Formatting... Formula is... and use the formula
(for the first row to not be shaded)
=MOD(RO...Creating a chart with varying data value ranges
I have a chart that I want to show home price data with.
The chart will have data that has very significantly varying data values.
For example, one line graph will be 50-100, one will be 400,000 to 500,000,
one will be 90% to 110%.
I would like to show these line graphs on one chart. How to I make a chart
with differing ranges on the x (vertical) axis?
Take a bit of seutp work, but the end result here is impressive:
BTW, the vertical axis is the y-axis.
"Anthony Blackburn&quo...Copy & Paste Chart
I can Copy & Paste an Excel Chart from one Workbook to another.
However, another User, when copying an Excel chart, and Pasting
into another Workbook, gets the Chart essentially as a "Snapshot"
TIA - Bob
What's your question? You don't say what you're looking for. What does the
formula bar say in parentheses after "EMBED"?
You can copy the chart as a picture: hold Shift while selecting the Edit
menu, choose Copy Picture, and choose the On Screen and Picture options.
Jon Peltier, Microsoft Excel MVP
Tutor...How do I sort data in excel by color?
Sorry, English isn’t my mother tongue, hope you’ll be able to understand my
I have a sheet with four columns of data. Three of them contain numbers and
the last one contains a word like the example bellow.
In Out Pending Name
1 3 2 Andrew
5 3 7 Mike
3 2 4 Andrew
2 7 1 Mary
4 5 1 Andrew
Now, if I want to quickly find all rows containing the word “Andrew” I go to
Edit, click Find and click replace and type Andrew into the “Find what” space
and Andrew into the “replace with” space. After that I format the fon...Bubble Charting
Hope you all can help, i've looked everywhere but have found it very
difficult to achieve what I want. I'm not familiar with VB but i know
how to copy and paste into modules!
Here is the data (column by column):
Name --- X --- Y --- Bubble Size --- RAG Status
OK, here are my requirements...
- Each bubble to be labeled with column name
- RAG status to conditionally format the colour of the bubble.
Thanks in advance!
You can do the colour coding by using multiple series and some simple
formula to create conditional charts,
this will give you more detail on the subj...Changing programmatically the color of a row #4
> once you have the conditional format set correctly all you have to do is
> rightclick on the mouse, copy, highlight the destination cells, paste
> special, formats.
> Or alternatively double click the "format painter" icon and highlight
> the destination cells/rows and leftclick to paste
Very thaks to all!
I have already sloved the problem...
Thanks for the help :p
masterx81's Profile: http://www.excelforum.com/member.php?action...Is it possible to create Graphs and Charts?
Our company is interested in making nice graphs and charts to use as maketing
tools for some data we have collected. Is Publisher capable of creating
graphs and charts. Excel doesn't give us the professional quality we are
trying to achieve. Thanks!!
Our corporate office uses Corel Draw and the graphs look amazing. If Excel
can create graphs like that then I need to know how.
"Ed Bennett" wrote:
> Erin LRX wrote:
> > Our company is interested in making nice graphs and charts to use as maketing
> > tools for some data we have collected. Is Publisher capable ...