A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : Charts and Charting Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
how to calculate the area under a curve by sealman9
I have data in excel in cells A10 through A100. I want to obtain the area under this curve.
March 16th, 2010 02:00 AM
by Bernard Liengme Go to last post
1 215
creating a formula that looks at the value of another cell and usesthat value as the row value for for a referenced cell by Kerry[_3_]
Seems simple enough, but I have no idea how to do this. Here's an example: =IF(ROW(A3)AO$1,'Page2'!$A?,""), where the question marks denotes the row number,...
March 16th, 2010 12:29 AM
by Kerry[_3_] Go to last post
2 102
chart by Kishor Bhalerao[_2_]
Hi!, I remember 2 years back i have done this type of chart from Scenarios or goal seek not excatly rem, but now i forget.. i want to do the chart in excel...
March 15th, 2010 06:09 PM
by Kishor Bhalerao[_2_] Go to last post
0 102
Secondary Axis - Alignment of Dollar Values by hans L
The dollar values for my secondary axis are left-aligned. I have tried various number/accounting formats but can't get them to right-align. There must be a...
March 15th, 2010 05:32 PM
by hans L Go to last post
2 160
Chart moves on plot area when adding a third month by Melody
I am working on an area chart that I update weekly. It's a very simple chart. The data looks like this: Month Count Jan-10 401 Feb-10 435 Mar-10 ...
March 15th, 2010 01:13 PM
by Melody Go to last post
2 170
Weird Excel diagram behaviour by Marcus[_5_]
Hi I have a very simple question. I wanna have a diagram with the following table Apple 30 40 50 Pears 200 300 400 Bananas 10 20 30 The weird...
March 14th, 2010 10:21 PM
by Bernard Liengme Go to last post
1 140
Chart Formatting by jlo
Is it possible to change the color of a bar chart depending on the value of a cell? I want the bar graph to show 2 colors BUT would like for the colors on...
March 12th, 2010 05:27 PM
by Luke M[_4_] Go to last post
1 119
Applying a Theme by cjdlb
I cannot get the theme to work on Excel 2007. It used to work but the other day when I was doing an assignment, it did not work. I'm not sure what...
March 12th, 2010 04:12 PM
by AdamV[_2_] Go to last post
1 142
Scatterpoot not using X values properly -- using relative ranking by Eric_G
I have created a scatterplot where the X value is to be one value (risk) and the Y value is to be another (return). I've entered the X and Y value ranges...
March 12th, 2010 04:08 PM
by James Silverton[_4_] Go to last post
4 138
Change background / color of chart worksheet? by Maj_USA_Ret
Need steps to change the color or backgound of the worksheet that is a chart. Have multiple tabs in workbook that are just the charts. Only option for...
March 12th, 2010 04:05 PM
by AdamV[_2_] Go to last post
3 189
copy chart between multiple sheets in workbook by Sam[_33_]
Hi, I have workbook with about 50 sheets. they have exactly the same table , just data(numbers in the table) are different. Also created a chart based on...
March 12th, 2010 03:59 PM
by AdamV[_2_] Go to last post
4 214
Excel 2007 - publish chart as htm web page file by nflfan
When I select a chart in Excel 7 and select Save As, I can choose file type Web Page (.htm file) just like in 2003, but it no longer gives the option to...
March 12th, 2010 03:05 PM
by AdamV[_2_] Go to last post
1 466
One Chart, Same Data ranges, different source sheets by Greg in CO[_2_]
Hi All! I have a sheet with numerous charts. The charts are standard, much like a dashboard. The charts are fed from one sheet which is a rollup of summary...
March 12th, 2010 02:57 PM
by AdamV[_2_] Go to last post
4 239
I can get line chart to ignore zeros but the legend still contains by jaimeo
Hi, I have a table linked to a series of worksheets. The table shows products 1 to 6 in cells A2:A8. It then shows sales for each year in b2, c2. c3 etc....
March 12th, 2010 02:22 PM
by AdamV[_2_] Go to last post
3 126
Changing ChartTypes will not change the color of the Series by EAB1977
I have Excel 2007 and trying to make this compatible with users that have Excel 2002/2003. I am having a hard time with the code below. When I change a...
March 12th, 2010 02:09 PM
by AdamV[_2_] Go to last post
2 130
Pivot table chart problem, How to show different subtotal levels by Ycorth
Hi, Using Excel 2003, I have a pivot table using external data via ODBC. I have a chart based on my pivot table. The table and chart are working...
March 12th, 2010 01:36 PM
by AdamV[_2_] Go to last post
2 124
Number and % on same chart by NM
A+B= x I want to show: -In one stacked column, I want to show (A+B) and in the same chart in a line form I want to show how much percentage is B. How can I...
March 12th, 2010 01:31 PM
by AdamV[_2_] Go to last post
3 106
How do I change the color of the timeline boxes in my Ghant chart by iswimfly100
My ghant chart automatically boxes out my time line when I input my start and end dates for each activity. How can I change the color of the time line? I...
March 12th, 2010 01:22 PM
by AdamV[_2_] Go to last post
1 138
how to copy sheet with charts without link to original data by Esty
I have a worksheet with ten charts on it. I need to copy the worksheet with all its data and related charts to new sheets or files so I have a page for every...
March 12th, 2010 01:15 PM
by AdamV[_2_] Go to last post
6 221
Source data - have X and Y values for 1 series by Tiffany
Someone before me had created a chart with columns and a line, but what I can't figure out is how they made the line the way it is. When I go to the Source...
March 12th, 2010 01:02 PM
by AdamV[_2_] Go to last post
4 101
Post New Thread

Display Options
Showing threads 281 to 300 of 15904
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

All times are GMT +1. The time now is 03:51 AM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 OfficeFrustration.
The comments are property of their posters.