Charts
in [Excel]
|
vba to hide two grouped charts in 2003 - doesn't work Hi, I have the following code which works fine in 2007. But since I have some users that still use 2003, when I save the spreadsheet in 2003 xls format, this code will no longer work. I found that when I ungroup the two charts, then it works fine. Do I need to use code to Ungroup them first, or is there a sim... 17 Dec 2009 17:05
How To Chart A Formula in Excel 2007 I'm looking to plot multiple formulas on a single chart, and came across a thread from 8/12/2005 for earlier versions of Excel for a single function, which causes errors when recreated in 2007. Error is A Formula in this worksheet contains one or more invalid references Verify that your formulas contain a vali... 19 Dec 2009 18:12
Charting with empty columns in between Let's say the data is Particulars Frequency q 5 w - e 6 r 7 While drawing a chart, it should not show wth column when it is 0, otherwise it should take it into consideration. How ? ... 17 Dec 2009 10:23
How do I make a graph with 2-cycle X 3-cycle log-log graph paper? I need to create a graph that uses 2-cycle by 3-cycle log-log graph paper. I was told that Excel can be used to do this. However, after fiddling around with it for an hour, I have been unable to figure out how to do it. Any suggestions? ... 16 Dec 2009 22:26
Displaying content of a cell somewhere on the chart Is it possible to display whatever value is contained within a cell (cell can be on the same worksheet as the chart or different worksheet, I don't care) somewhere on a chart? I would love for it to be in the title. For example, on Worksheet A I have cell A2 containing 4 Hours. I then have a chart on that works... 18 Dec 2009 10:31
Excel 2007 Having problems dragging text from one cell to another without moving outside boaders lines? ... 15 Dec 2009 11:11
VBA Axis line weight I am trying to set a number of parameters on a chart but am missing a way to set the axis line thickness (weight)? I have XLS 2007. With ActiveChart.Axes(xlValue, xlPrimary) .AxisTitle.Font.Name = "Arial" .AxisTitle.Font.Size = 12 .AxisTitle.Font.Bold = True .AxisTitle.Font.... 17 Dec 2009 10:23
Copy chart with associated table I have a table with a chart alongside that is neatly tied to it. I now want to duplicate this chart / table pair multiple times on the same sheet so I can change the table data and get unique charts. I select all the rows that contain the table / chart pairing then copy and paste them down below. I now have ... 12 Dec 2009 21:08
SeriesCollection(10).Name = "=""""""NBT""""""" What are all these quotes? Excel 2007 Chart VBA with lots of quotes, and alternate variable presentation. http://www.mediafire.com/file/owfzdzmzw23/12_12_09.xlsm ... 12 Dec 2009 14:35
Using drop down lists I'm trying to create a report utilizing a drop down list in Excel. I have successfully created the drop down list, (I'm using every Monday in January as my different items on my list) but now I want to enter different data using the same rows and columns for each specific date. This is just a worksheet that ... 11 Dec 2009 14:44 |