show value as percentage in stacked bar graph
I work for the Court and I am trying to show the percentage of 2 types of
cases (CC and SP) to the total judicial caseload, in five different separate
locations, on one graph. I developed a stacked chart which shows the values
(number of cases) of each type (CC or SP) per location. I was also able to
also show the value only of the total number of cases (CC + SP) and keep the
original chart format without adding a third stack on top by entering a third
series as the total value, but making this series transparent and aligning
the total value at bottom of stacked series of CC & SP...button bar event handling?
I created a MFC app that uses ODBC to access a database. I can't figure out
what methods the buttons end up calling. I used the classwizard and it says
the handler is OnRecordNext. I added a method OnRecordNext to the view, but
that doesn't get called.
...My Network Places
For some reason, when I click on Start | Run | Browse, My Network Places
is not one of the options to Browse. My Network Places is on the desktop
and works normally. The options available are My Recent Documents,
Desktop, My Documents, and My Computer. It's a fresh build of XP on this
machine, so I've probably forgotten to configure something.
> For some reason, when I click on Start | Run | Browse, My Network
> Places is not one of the options to Browse. My Network Places is on
> the desktop and works normally. The options available ar...My Bar Graph is getting chopped off
I have a bar graph and my last data point has been cut in half becuase the
category x-axis ends. How do I extend out the x-axis so I don't chop off
half of my last bar?
Right click on x-axis (to open Format Axis menu)
Open Scale tab
Place check in "Value (Y) axis crosses between categories
Bernard V Liengme
remove caps from email
"Alexis" <Alexis@discussions.microsoft.com> wrote in message
>I have a bar graph and my last data point has been cut in half becuas...place cards or tent cards
i see the card stock for these. but i do not see the stocks as an option
when i try to do them in word or publisher. does this make sense? help!
In Publisher, first set the stock size with File, Print setup then the File,
Don - Publisher 2000�
"strawberryangel83" <firstname.lastname@example.org> wrote in
>i see the card stock for these. but i do not see the stocks as an option
> when i try to do them in word or publisher. does this make sense? help!...population pyramids using bar charts with a secondary axis
I have a problem that I had given up as unsolvable, but after recently
learning about secondary axes, I've made encouraging progress. However,
I'm stuck on the last step(s), and I'm hoping that someone will have
My organization has been producing reports that contain population
pyramids. In the past, all of their reports have been printed, so it
didn't matter that in order to get the desired look, they had to use
two charts slightly overlapping each other. However, we are getting to
the point where we would like our charts to be available online for
download....Missing Formula Bar
I am no longer able to enable my Formula Bar. Under the
View menu, I can check Formula Bar but the bar is not
visible either when this option is checked on or off. I am
running Microsoft Excel for Mac Service Release 1 with
Office v.X 10.1.5 Update.
Application.DisplayFormulaBar = True
I don't know if this is working for a Mac??
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
"Barrie Thomson" <email@example.com> wrote in message news:firstname.lastname@example.org...
> I am no longer able to ...Move a dialog based application without the title bar
I have created a dialog based application without a title bar, and
want to move the dialog using the left mouse button.
I tried MoveWindow nut the window was streching instead of moving !!!
Can anyone help me please?
>I have created a dialog based application without a title bar, and
>want to move the dialog using the left mouse button.
>I tried MoveWindow nut the window was streching instead of moving !!!
MoveWindow can resize and move the window, so you've got a coding
If you use SetWindowPos you can specify the SWP_NOSIZE option to have
it ignore the cx & c...Pivot table total decimal places rounding
The totals in my pivot tables have too many decimal places.
I total -$1,025.31 and $1,023.87 and the result is
$1.43999999999994 in the total cell of the pivot table but
I need just $1.44 I have formatted the table as currency
and using 97.
Pivot tables can lose their formatting if the data is refreshed. Reapply
the formatting, and make sure that 'Preserve formatting' is checked
(under PivotTable>Table Options).
> The totals in my pivot tables have too many decimal places.
> I total -$1,025.31 and $1,023.87 and the result is
> $1.43999999999994 in the to...Bar chart with secondary axis
I am currently using Excel 2002 on a Windows XP system. I
am trying to create a bar chart with 2 series and a
secondary axis. The bar chart looks fine with the two
series side by side. Then I open the second series and set
it to a secondary axis, the chart preview looks correct
with the series still side by side. I hit OK to complete
the operation and Excel stacks the chart and does not look
like the preview at all. Can anyone tell me if this is
working as intended or am I running into a bug here. Is
there a workaround for this issue?
Hi George -
When the series are on di...Linking a Bar Chart
I have a bar chart linked into my active worksheet. The
linked bar chart is based upon data that is using a named
range - specifically using the offset formula function. I
used this formula to automatically update the chart based
upon the new month's data.
However, my active worksheet will not update any changes
to the linked bar chart.
When I try to update it manually I get the message that
says: "The name you specified is defined as something
other than a rectangular cell reference". Anyone ever see
this? Any thoughts on how to work around this?
What is ...Add a drob down list box to the tool bar?
I'm working with Microsoft Visual C++ 6.0. The software I'm working on has
a main window that brings up other windows when you click on various buttons
on the tool bar. I need to add a drop down list box to the tool bar to
select between 2 different modes. How do I go about adding a drop down
list box on the tool bar?
Don't you mean a combo box? There are good samples in toolbar section of
Ajay Kalra [MVP - VC++]
"Lee ALICEngineer" <LeeALICEngineer@discussions.microsoft.com> wrote in
message news:9620EAA...Stacking Single Bar Graph
Need to find a graph that stacks a series of values in one bar. I know that
the stacking graphs should work, but I can't seem to figure out how. For
example, $100 total with $25 for Susie, $50 for Bill, $15 for Jane, and $10
for Mark. Each of these need to have separate manipulatable colors and text.
Thanks in advance.
Enter the names and amounts in adjacent columns on the worksheet:
Select a cell in the list, and click the Chart Wizard button
Select the Column chart type, and the Stacked column subtype
On the Data Range tab, select Series ...Tools Icon on Excel Menu Bar Missing
I don't know what I did, but the Tools Icon on my Excel
(2000)Menu bar has gone missing. I've even tried re-
installing Office 2000, but I didn't get it back. Can
You can reset your menubar to default
Right click on the menubar and choose customize
Under Toolbars select the worksheet menubar
and click on reset on the right
You lost the things you add to the menubar!!
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
"GHO" <email@example.com> wrote in message news:firstname.lastname@example.org...
> I don'...keeping calendar and folders in navigation bar
ol03. i have navigation bar open. i click on calendar button (small icons)
at bottom and calendar opens showing several months. i then click on 'folder
list' icon, and folders show on navigation bar with current month still at
top. that is perfect. except if i click on one of the folders, the month
disappears and folders take up the whole nav. bar.
isn't there a way to keep calendar and folders open at same time?
...Filtering the todo bar
Is it possible to show all uncompleted items and items completed in the past
week? I can't seem to figure out how to do this.
You can use tag searching to show unchecked boxes - I blogged about this last
I don't think there is a way to tell which tags were modified in the last
two weeks, though. You could possibly write a powertoy to dig this
information out, but I don't think it would be trivial...
OneNote Test T...stacked bar chart #4
I have a chart that has dates, (month,year) as the y axis from 1/2003 thru
4/2006. The x axis is 3 of 15 (top 3) of a series of data. My question is
can the bars be displayed so that the highest valued data is on the
top/bottom of the bar and vice versa. I can't enter the data differently
because each month it is not always the same top 3 and I need to keep the
...fx in Formula Bar
I've used quite a lot Excel 2000 and now I'm using Excel
2003. In the formula bar, there is the "fx" to insert a
function. In Excel 2000, it used to be "=". Is there a
Excel 2003 to show "=" instead of "fx".
No, it's one of the more missed things..
"PeteD" <email@example.com> wrote in message
> I've used quite a lot Excel 2000 and now I'm using Excel
> 2003. In the formula bar, ...Trendline on stacked bar graph
How can you add a trendline to a stacked bar graph? Thanks
Joni's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=13596
View this thread: http://www.excelforum.com/showthread.php?threadid=513635
Keep in mind that a stacked chart depicts a sum of one or more series, not
just each series. Trendlines only work on individual series. You could
either generate trendlines for each series on a non-stacked basis, or you
could add dummy line chart series to the stacked column chart...LOST: Formula bar
I used to have a formula bar, which included a window
showing which cell I was using and the contents of a cell
(formula or numbers). I've lost it. How do I get it back?
View>Formula Bar on the Worksheet menu bar
Regards Ron de Bruin
"Stephen Esrati" <firstname.lastname@example.org> wrote in message news:Iygcc.11368$SQ5.email@example.com...
> I used to have a formula bar, which included a window
> showing which cell I was using and the contents of a cell
> (formula or numbers). I've lost it. How do I get i...How to disable the scroll bar in CSCrollView
I want to display the scroll bar in the CScrollView derived windows, but if
there is no need to scroll I want the scroll bar is disabled, is it possible
to do this?
...possible to hide the Service bar on left?
Is there a way of hiding the Service bar in the left hand pane from selected
Yes, simply click on Workplace bar, then just above click on "personalize
Workplace" then tick on or off what you need
"GP" <GP@discussions.microsoft.com> wrote in message
> Is there a way of hiding the Service bar in the left hand pane from
...Horizontal Scroll Bar Does Not Scoll
I do help desk work and I have a user that is unable to scroll to the right
in Excel. It doesn't matter if it is a new spreadsheet or an existing
spreadsheet. Same symptoms. I am unable to find an settings that would
cause this so not sure where to go with it.
Has anyone seen this before?
...vertical vs horizontal error bars excel 2007
> Where do you differentiate if you want vertical or horizontal error bars?
> When I go to more options and select custom, it always chooses either
> vertical or horizontal for me (often incorrectly). Also, it sometimes says
> it is doing vertical error bars and then actually makes horizontal ones.
> Help anyone?
This has bugged me as well; the new error bar interface is incomplete and
confusing. I don't know why they took it out of the Format Series dialog. If
you go to Chart Tools > Layout tab > Analysis group > Error Bars dropdown >
More Error Bars...Putting scroll bars on chart sheet
Does anyone know if it is possible to add scroll bars onto a chart sheet?
Thanks for any suggestions.
You can add the scrollbar from the Forms toolbox, as opposed to the
> Does anyone know if it is possible to add scroll bars onto a chart sheet?
> Thanks for any suggestions.
Andy Pope, Microsoft MVP - Excel
Thanks for the reply, but that doesn't work. The tool box becomes grayed
"Andy Pope" <firstname.lastname@example.org> wrote in me...