Graph Line Width ?12043 (4/7/2012 2:01:48 PM) rgsrose1(8)Hello, Using Excel 2007. Dumb question, but I just can't seem to get it to work. Have a chart with a line graph. Guess it's called a Scatter Graph. Bunch of points, with lines connecting the points; the typi...
Change font in multiple charts and graphs01657 (3/23/2012 12:01:37 AM) andrea.anonymous(2)Hi, is there a macro or other global solution that will save me from changing the font for every element in an excel spreadsheet with 75+ charts and graphs? I'd like to retain all other formatting. Thanks in ad...
Excel 2003 dynamic named range for the values in a pie chart11908 (2/13/2012 8:03:48 PM) wyan.org(1)Hello, In Excel 2003, I've been trying to use a dynamic named range for the values in a pie chart: =Cost Ctr Summary x Project!PieData12 But it won't accept that. Keeps telling me: "A formula in this worksh...
Dynamic (?) chart01759 (2/9/2012 7:13:41 PM) Hooligan.979d8a8(1)I have a variety of data lists (production levels, sales, labour costs) that are calculated and combined into a summary table for my production mgmt to review. The lookups etc. are based on a date range entered...
reverse axis not working as before...01284 (2/7/2012 3:53:13 PM) bbowler(11)This code "worked" in 2003, but doesn't "work" in 2007... In this context, "worked" means that in 2003, the X axis for both Y axes were reversed, as requested. In 2007, only the X axis for the primary Y axi...
elisa standard curve fit32808 (1/30/2007 10:55:00 AM) G1(145)I am a biochemist and I am wanting to be able to plot immunoassay (ELISA) data. In particular I want to be able to produce standard curves using a 4-parameter logistic curve fit and read the values of 'unknow...
Two issues with axis labeling11357 (1/16/2012 8:29:26 PM) lumberzach.95a8908(1) I have been having a few issues with getting my figure just right in excel. My two main issues are as follows: 1. Is there a way to use scientific notation for all y-axis values except zero? It just looks sil...
how to display Timestamp on x-axis in Scatter smooth line graph01267 (1/21/2012 8:45:06 PM) bugserm.9612089(1) hi all.. i,m using excel 2010 on windows XP. i want to display timestamp on the x-axis in the format hh:mm:ss for example from 17:18:48 hour till 23:59:56 hour instead of just integer i.e 0 to 5000. any help w...
how to change color gradients in a bar chart01281 (1/21/2012 1:46:48 AM) dclerch(1)Despite a lot of Google searching, I could NOT figure out how to change the colors of the gradient in a bar chart in Excel 2007. So once I finally figured it out on my own I figured I'd post it here in case any...
Plotting a 3D Bar Chart11452 (1/10/2012 11:07:41 PM) ZewSays.952a009(1) Hi everyone, I am doing a research on international oil and gas trade. The data table that I have looks like a typical train schedule. Each row represents oil exporting countries; each column represents oil i...
Displaying The Chart In A Full View ?01313 (1/8/2012 5:18:17 PM) rgsrose1(8)Hello, Using Excel 2007 Have created a chart, and it looks just fine. But, in the chart view sometimes it seems to open up, centered, but only using perhaps half of the available screen area. Big, blue, non-...
Move bar chart to behind lines01453 (1/7/2012 4:24:47 PM) FI have a chart which holds a bar series and two line series. The bar series is displayed behind the lines (ie, they are drawn across the front of the bars) but I would prefer it if they were drawn behind the ...
remove "linear" from trendline legend entry11693 (12/19/2011 5:23:01 PM) dschneid(1)Hi, I am plotting some data but I only want to show the trends so I've hidden all the scatter points and am showing just the linear trendlines. However, the legend entries are Linear (April), Linear (May) etc...
Macro help please01293 (12/15/2011 5:58:16 PM) Terri817(2)I have three columns (A, B, C) on a sheet (Data) -- in column A "names" are listed (one name can be listed multiple times) -- column B is a list of "training courses" that the employee has taken -- and C has a ...
Triangulation using excel12309 (12/12/2011 3:36:58 PM) donald.ross.ctr(1)Good Morning, I would like to better understand the method or methods used to calculate and determine bearing and distance from a known point based on observation(s) from two known points. Let me explain mor...