Change bars color
I have a dinamic chart to show the cash flow position, a scrool bar chagne
the data to the past and to the future (estimate), what I am looking for is,
to have an easy identification of the estimated period I would like to chage
the color of the bar.
I am using an Stacked Column chart with two variables.
regards from Brazil
Thanks in advance for your feedback.
What I usually do when I want to show a column chart with one color within a
certain range and another color elsewhere, is create two series, one each
color, and use formulas to change on series ...Chart Help Please!
I have a very simple chart...
The data looks like this:
The data charts fine and looks good but right now the bar for Data1
and Data2 are the same color. is there a way to have the bar for data1
one color while data2 is a different color?
Thank you all for you excellent help!!
Select the series and Format Data Series>Options>Vary colors by point.
Select the series and Format>Date Series>Fill>Vary colors by point.
Gord Dibben MS Excel MVP
On Sat, 28 Nov 2009 11:32:02 -080...Can the color of the Command Bar be changed?
When you open up a window to show the contents of a folder, just below
the usual Menu Bar is the Command Bar with menus like "Organize" and
That Command Bar has a sickly blue-green color.
Is there any way to change the color of the Command Bar? At the very
least, I would like that color to be less saturated.
-- Steven L.
...Font size across platform
Why do documents when opened in Macintosh are rendered a lot smaller
(visually) than when opened on a PC?
For example - if an excel document is created using 12pt Times New Roman, it
is perfectly legible when opened on a PC. When done under osx, it is tiny
and so you have to zoom in to view it (to 125-130%). If you save any
changes, then the zoom is saved.
So what? I am an independent consultant and work in teams that primarily use
PC and there is constant filesharing between team members. It is a real
nuisance when transferring files, especially clients who sometimes reduce
the font...Muliple Charts from one Pivot Table #3
Many thanks . That worked a treat. Just need to to the pivot item o
the chart now.
TJonesEsq's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1532
View this thread: http://www.excelforum.com/showthread.php?threadid=26951
...DATE sort bar has disappeared from SENT box
I've inexplicably lost my DATE sort bar in my SENT box.
Outlook 2002, XP Pro.
I've dug here and scratched there, but cannot uncover an
answer as to why it's missing and how to get it back.
Hit the OfficeUpdate.com website to engage in Office XP
SP 1 and/or 2...I'm current, but alas, still no DATE sort
bar in the SENT folder.
One little bar--so valuable--so easily mis-placed!
Thanks for any advice--
Timmo in AK
Try right-clicking in the gray title bar, then select to
customize your current view. Click on the "Fields" button
to see the list of available fi...Resize a Pivot table Pie Chart
You can change the size of the plotting area on a normal Excel chart. How do
you resize the plotting area on a Pivot chart?
> You can change the size of the plotting area on a normal Excel chart. How do
> you resize the plotting area on a Pivot chart?
Pivot Charts are handy, but quite limit your ability to format. I get
around this by adding a worksheet that references values from the pivot
table, and base the chart on the latter.
...How can I change the size of different series within a legend?
I have several data series with different amount of text in the legend. At
the moment,excel provides automatically equal space for all series, but i
need for some series more than for others, otherwise the legend gets too big
and i have to maximize the chart, which i do not want.
Is there a way to adjust the space according to the needed space?
It is not clear what you mean by "Excel provides automatically equal space
for all series"
Why not just use abbreviations in the legends
You do know you can drag the legend box anywhere you wish on the chart?
Bernard V Lie...Chart date order
This is weird. In 2007, if I display a chart for a payee (double click on a
payee from the payee list), the chart sorts from left to right, with the
most recent on the right, as it always has.
But if now display a chart for a catagory, the chart now sorts from right to
left, with the most recent on the left.
That had me confused for some time before I noticed the date order change.
Was it like that in 2006 or is that new for 2007? I don't see the sense in
In microsoft.public.money, Bruce Chastain wrote:
>This is weird. In 2007, if I display a chart for a paye...100% Stacked Bar chart, two bars, want percent as well as real value
I am attempting to chart the following:
Series 1 - Values over the prior 30 days
Series 2 - Values over the prior 12 months
I would like to show both data series as 100% bar charts, so users of
the information can compare percentage of the last 30 days with
percentage of the same piece of data over the last 12 months.
So, for example the two data series might look like this:
I want to display both the actual value, and the percentage of the
total, for each series, in the labels. For some reason, showing
percentage is not an option. Why is th...EMail fonts, sizes and color
When I change my font type, size & color I can only click OK (tool-options).
Once I close Outlook it returns to the default font type, etc. How can I
change my default?
CD <CD@discussions.microsoft.com> wrote:
> When I change my font type, size & color I can only click OK
> (tool-options). Once I close Outlook it returns to the default font
> type, etc. How can I change my default?
What version of Outlook, what message format, what Outlook editor, and in
twhat window are you trying to make these changes? You're a little short on
Brian Tillman [...a frame window with its title bar on the top of its menu bar (overlapped) ...
This is related to a previous post of mine, for which I got a lot of help
from people but the problem was still not resolved. I am reducing the
problem to the following piece of code with only one class (CFrameWnd)
involved. Please bear with me to look into the problem one more time.
HINSTANCE h = AfxGetResourceHandle();
CFrameWnd *pFrm = (CFrameWnd*)RUNTIME_CLASS(CFrameWnd)->CreateObject();
pFrm->LoadFrame(IDR_MAINFRAME, WS_OVERLAPPEDWINDOW | FWS_ADDTOTITLE);
AfxSetResourceHand...X error bar
Hello, I can find in Format Data Series the 'Y Error Bar' but nowhere can I
fnd the 'X Error Bar'. How can I get this one?
In order to have x error bars you need to use the xy scatter chart.
> Hello, I can find in Format Data Series the 'Y Error Bar' but nowhere can I
> fnd the 'X Error Bar'. How can I get this one?
> Office 2000.
> Thank you
Andy Pope, Microsoft MVP - Excel
...how do I create an orgnaizational chart with 5 boxes at the top?
I am trying to create a chart for my company where there are 5 linked boxes
at the top, then subordinates underneath. However, powerpoint will only let
me have 1 box at the top and then 5 boxes underneath.
What do you want beneath the 5 boxes?
This is relatively easy to set up.
"Jammie Dodger" wrote:
> I am trying to create a chart for my company where there are 5 linked boxes
> at the top, then subordinates underneath. However, powerpoint will only let
> me have 1 box at the top and then 5 boxes underneath.
>...Reading Pane Text Size
Okay, if you click on the grey area surrounding the reading pane in
Outlook 2003, you can adjust the text size to largest. Is there a way
to make this permanent? Thanks!
Not that I know of, but if you click in the message body, then hold down the
control button and scroll, you can adjust the reading font to your
preference. This must be done on a per message basis, however.
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. All
unsolicited mail sent to my personal account will be deleted without
After furious head scratching...building chart from multiple sheets
I have 5 sheets and would like to build a stacked bar graph using data from
each. Say I have 4 values in A1, A2, A3 & A4 on each of these sheets. Each
stacked bar is to respresent the 4 values from a single sheet. Is there any
way to do this with out having to build a table on an extra page?
If I understand your data structure, you will need to use a range to
consolidate the data.
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://...looking for a yearly flow chart for amount spending for advertisi.
you may provide some more detail :-)
"maggie" <email@example.com> schrieb im Newsbeitrag
...How do you add error bars?
when i select my data series on my table, no selected
data series appears under format
Instead of selecting the series on the table (whatever that means), try
selecting the data series in the chart.
MS MVP Excel 2000-2004
Excel, PowerPoint, and VBA tutorials and add-ins
Custom Productivity Solutions leveraging MS Office
In article <firstname.lastname@example.org>,
> when i select my data series on my table, no selected
> data series appears under format
...How do I break a csv file into smaller size for export?
Need to export an excel database (2003) consisting of 6800 names for use in a
another program. Need to break up the csv file into smaller size before it
can be imported.
Cut and paste half the names to another workbook and save as *.csv?
Filter out what you don't want and delete it?
Without more detail I can't come up with anything else.
Hang in there, someone may interpret your need differently.
Gord Dibben Excel MVP
On Wed, 21 Dec 2005 14:03:03 -0800, svb <email@example.com> wrote:
>Need to export an excel database (2003) consisting of 6800 names for u...Dynamic Chart #7
I have a spreadsheet that has its data in the following format:
2003 2004 2005 2006
Company 1 1.5 1.63 2.1
Company 2 .75 .89 1.09
How can I create a dynamic chart so that when I input the data for 2006 (and
forward) the chart will automatically update. Thank you in advance for any
I'll walk your through setting up a dynamic chart, however, I'd liek to
suggest you rearrange your data table as follows:
Year Company 1 Company2
20...How do I show status bar on Publisher 2003?
The Status Bar in Publisher 2003 which is at the bottom of the screen and
shows many page numbers suddenly vanished. I see no way of makling it
reappear. This toolbar was called "Status Bar' in Office 2000 - Publisher'.
There is no reference to this item in Pub 2003.
2. Pub 2003 has slowed down almost to a halt. If I insert a woed text file,
it takes a couple of minutes per page; and then, even after a long wait, it
does not insert all pages of the inserted document. It has to be done
3. While using Pub 2003, the response to move from one page to another,
appear...Stacked bar, bar and line graph
I am trying to create a chart with the following data:
Series 1-8 with bars
Series 9-10 with stacked bars (two different data)
Series 1-10 with a line across all
Is this possible in one chart?
This should give you ideas:
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
"JoAnn" <JoAnn@discussions.microsoft.com> wrote in message
I am trying to fix a db created by someone else. Somehow, I'm hoping you can
explain, they disabled the status bar. I check the Options and it is still
What other means could be used to disable it? How can I make it visible
Two places... Start-Up Properties and Tools - Options... one of those is
2010 Microsoft MVP (Access)
"I feel I have been denied critical, need to know, information!" - Tremors
"QB" <QB@discussions.micros...Getting "Accounts" on menu bar
My girlfriend has an "Accounts" button on her menu tool
bar (not sure which one, advanced, standard???) which
allows her to select which account she's sending an e-
mail "from". I can't find a way to find that item to put
on the menu bar. Please help.
This is available in Outlook 2002 and later. What version are you using?
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, all mail sent to my personal
account will be deleted without reading.
After searching googl...Excel charts lose color
I am losing the color on my Excel 2000 charts when I copy
them into an Outlook 2000 email message. Anyone have any