I would like to do a combo chart. Any ideas?
Plot all the data in a chart using the chart type you want to use for
most of the series. Select one series you want to change, choose Chart
Type from the Chart menu, and pick the chart type you want for this
series. Repeat for any other series you want to change.
Excel offers some built in combo types, but it's easy to make your own,
and you can be much more flexible this way.
Jon Peltier, Microsoft Excel MVP
> I wou...Displaying MS Excel Chart control in ASP.NET Application
We are working on an ASP.NET (VB.NET) application. In one of th
screens of our application, we need to show a graph and for this we ar
using MS Excel Graph control. We have the graph prepared in Excel. Th
application would feed in certain values into certain cells of th
excel file and the graph would be drawn by the graph control based o
We need some help on how exactly to display the excel graph contro
directly on the screen of ASP.NET application.
Thanks for the help
I presently have an XY line chart showing asset price over time. Pretty
X Axis - Time Scale
Y Axis - Asset Price
I would now like to add an additoinal series showing the volume of
assets traded, ideally this would be as a bar chart sitting
"underneath" the asset price on the chart. They would share the same X
I have added another series, but this simply displays the volume traded
as another line, and even when this is set to a secondary axis the
scaling makes this unworkable. i have adjusted the scales of both,
still this does not make it workable, i want the series...Copying data from one chart to another
I have many graphs - all plotting on similar scales but using different
data. Is there any way I can simply copy one set of data from one graph
and paste it into another graph so that I can avoind going through all
the hassle plotting each curve again? I want to have graphs showing
different combinations of the same data and have hundreds of curves to
plot so this could be a huge timesaver...
Alan_Partridge's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29295
V...Line Chart with dates in 5 day working week only
Trying to format a chart so that only the 5 working days of the week are
displayed on the x axis. The source data only has the five days (e.g.
05/09/2005 down to 09/09/2005 and then on to 12/09/2005 down to 16/09/2005
etc etc) So I have missed out the weekend dates.
When I create the line chart however, the weekend dates appear automatically
and just show no point on the chart, therefore there is a longer line between
Fridays and Mondays!!
Hope this makes sense.
Does anyone have any ideas on how to change this? I have tried looking at
Tools-options-chart and cannot seem to turn...Visio 2003--Can't drag objects from templates into flow charts.
Utilizing Visio 2003 in an Microsoft XP environment, I have not been able to
drag objects from templates onto flow charts. I do not understand why.
...Time performance Chart
I need to develop a chart that graphically depicts an employees start
time and end time each day. This chart would be a bar chart. The bar
chart would have days of the month along the bottom, and the side
would start at 00:00 at the bottom and end at 24:00 at the top. I
need to be able to enter an employees start time and end time and have
it charted along the bar. So if the employee started at 07:00 and
ended work at 18:00, the chart would show a colored bar that
corresponds to the start time and the end time. Also, if an employee
came back to work the chart would refl...Custom Toolbar in Chart
How do you create a custom toolbar with a ComboBox that will be avaliable
when a chart is active?
I'd like to have a TOOLBAR where a ComboBox (or ListBox) is used to select a
variable. This would then change the source data for the chart. I've got
the code to change the chart, I just can't get a ComboBox in a Toolbar to
work properly when a chart is active.
I'm not sure what you mean by "I just can't get a ComboBox in a Toolbar
to work properly when a chart is active." If you mean it should be
active only when a chart is...
One 'tric...... I want to change a chart type ...
I have a "Line - Column" chart in my spreadsheet.
My Bars represent the month which is in a Linked Cell.
The Value of the Bars is a Dollar amount from a Linked Cell.
The Line represents a Target Dollar Value.
I would like to add a second line that would represent a count from a linked
range of cells.
Can I edit my existing chart, or do I have to create a new one? Could you
give me a few pointers?
Select and drag the new column onto the chart. In the resulting dialog
box, ensure you specify 'new series'. Once XL finishes adding the
series, if it is not the...Chart
Does anyone know if there are some "Add-Ins" for Excel that allow to use
gauges that look like "Speedometers" (circular gauges)?
Please refer to
http://www.infommersion.com/demos/portlets/demoshell.html#demos for the kind
of graph I'd like to include in a spreadsheet.
Tom, see if this will work for you
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Exc...Right click in Pivot Table or on Entire Column
I have added items to the right-click menu that popups up when you have a
cell or cells selected. But when you are in a Pivot Table or have an entire
column selected the right-click popup is different.
Is there a way to add an item to the right-click popup menu when you are in
a Pivot Table or have an entire column selected?
Thank you for your help.
Never mind. This one was right in the help section. I should have looked
> I have added items to the right-click menu that popups up when you have a
...Problem with charting Net income vs Year
Im having some problems with my Excel chart. It will not plot Net Income vs Year. It keeps trying to treat Year as a different data series. It will work if I use text i.e. a1990, a1991, etc. but it refuses to use 1990, 1991... Any Ideas???
Use an "XY (Scatter)" chart, instead of a "Line" chart.
> Im having some problems with my Excel chart. It will not plot Net Income vs Year. It keeps trying to treat Year as a different data series. It will work if I use text i.e. a1990, a1991, etc. but it refuses to use 1990, 1991... Any Ideas???
Delete the co...Display Report Header/Footer
Can somebody please give me the telephone number of the smartass MS VP who
came up with the bright idea for the Ribbon so that I can call her and have
her tell me how to display the Report Header & Footer in a report?
Obviously, I must be an idiot because I can't figure out how to do it with
this simplied, intuitive, help-ya out m***** fu***** ribbon.
Oh stupid me, its under 'ARRANGE'. How idiotic of me to think that it'd
under 'DESIGN' since I'm 'designing' a report as opposed to 'arrangeing' a
"microsoft"...OWA Premium Client Not Displaying Correctly
I wonder whether anyone has seen this problem before because i would
really appreciate any help on this one please.
I have six Exchange 2003 servers in my organisation and there are two
Exchange servers in three sites. Four of the Exchange servers are
running Windows Server 2003 and Exchange Server 2003 [With Exchange
SP1]. The front-end server is running Windows Server 2003 SP1 and
Exchange Server 2003 SP2. Users with mailboxes on those four Back-End
Exchange servers do not have any problems using OWA.
The two Exchange servers on my site are using Windows Server 2003 SP1
with Exc...How do I make X-values of a chart dependent on values in cells?
I have a chart which can go from x-value 0 to x-value 200. However
I'd like to be able to input min X-value into a cell, and a max X-valu
into a cell, and the x-value in the chart changes to reflect that.
Is it possible to do that?
Thanks for any replies.
Message posted from http://www.ExcelForum.com
There is no automatic way to do this but take a look a Tushar's
AutoChart Manager for a possible solution.
Kashgarinn < wrote:
> I have a chart which can go from x-value 0 to x-value 200...Pie Chart Plot Area Moves
After printing a pie chart, the plot area relocates itself. I wrote a
procedure to bring it back to the designated "top" and "left" coordinates
the next time the sheet is activated, but the plot area doesn't relocate
until the sheet is activated a SECOND time. Does anyone know how to fix?
...Right click mouse no menu
Outlook 2003, Windows XP, SP2. Since a while (context unknown) when I
right-click an email in a folder the menu that normally pops up (with options
like open, mark as read, delete, etc.). This Menu doesn't come up any more.
On a another Laptop and on a Desktop (same revision level) it works.I did a
repair of office. No luck.
Looks like this is a know problem (you can search forum for occurence of
"right") but no solution provided yet. Any suggestions, solutions?
If you close and reopen Outlook, does it work again? How about after a
reboot of Windows?
Milly...Right-click menu does not appear
I am having an issue with Outlook 2000.
I have installed Microsoft Outlook 2000 with Office 2000 SR-1 and SP3. When
I log on as the user (with or without local admin rights on the machine)
then he cannot right-click on messages in his Inbox. Right-clicking works
fine on any of the folders in the folder list. In the message list, no menu
pops up at all. When I am logged onto the computer as myself (with domain
admin rights) it works fine.
None of our other Outlook installations are having this issue.
The computer with the issue is a Dell Latitude laptop running Windows XP
Professional wi...how do i read directly off of a chart
i've set up a callibration curve in excel, I have experimental x values and
want to obtain the corresponding y values without using FORECAST, TREND tec.
Search the newsgroup archives for 'interpolate'
or if you want to try to match the smoothed curve Excel draws arbitrarily through
points, google the groups for 'Dave Braden' and 'cubic spline', or go to Brian
Murphy's site, and look for the Excel Stuff link, which includes a treatment of the
bezier function used by Excel to draw this curve:...Altering the range that is plotted by a chart via VBA
Good morning all.
I haven't really done a huge amount on charting, so I'm sure you'll think
that these questions are a bit simplistic, but here goes!
I plot a chart from a worksheet that contains three columns of data - the X
axis contains week numbers, and is in B29:B54. Actual hours are entered in
F29:F24 and cumualtive hours in G29:G24. The cumulative formula is of the
So, each week, in order to plot another week's data, I have to copy this
cumulative formula down by one cell, which, considering I have a lot of these
reports, is a bit time cons...Line Chart;Linear Trend; What's the Math behind it
Do you know what the math is behind the Linear Trendline which results when
right clicking on a line chart?
The "Linest" function in Excel help has an explanation.
Portland, Oregon USA
(Excel Add-ins / Excel Programming)
wrote in message
Do you know what the math is behind the Linear Trendline which results when
right clicking on a line chart?
Thanks, Jim. I did try help but I was search...Cannot Edit Charts in PPT2007
Problem: I cannot edit Charts after they are created and save. When I click
on the Edit for the chart, task manager indicates the EXCEL.EXE task is
launched, but the worksheet does not appear. When creating a new presentation
and a new chart, everything works the way it should. After saving the
presentation, Its broken? This must be some sort of Registry setting, I've
re-installed Office 2007 Standard, run Diagnostics, all to no avail. The Same
saved presentation works properly on another PCs Powerpoint 2007 in the same
Have you installed SP2 for Office 2007?
-- ...Charting with IF Statement
I have the following IF statement:
In charting this data, the "" is charted as a 0 instead of a blank. I want
it to be a blank. Is there a way around this?
The #N/A error is ignored by charts.
Please keep all correspondence within the Group, so all may benefit!
"Bill" <email@example.com> wrote in message
I have data in a chart that ranges from a lower end of 1-200 and numbers that
resume at 140,000 and continue on to 700,000. I would like to be able to
show them so that the lower end numbers are still visible but show that the
middle section (500 - 50,000) have been cropped from the image. Is this
possible, or do I need to make separate charts and treat them as images in
order to achieve this effect?
Take a look at Jon Peltier's tips about a Broken Y Axis.
"alex" <firstname.lastname@example.org> wrote in message...chart auto
i am studying statistics and i have something to do but i don't know. i want
to make a work book which i entry a value every month, i want every month the
bar chart which i have created to auto add the value of the new month. how
can i set the properties in the bar chart like, every month of every year to
have the same color (auto)?
Thank you for your time