Search Results

Search found 5003 results on 201 pages for 'excel charts'.

Page 5/201 | < Previous Page | 1 2 3 4 5 6 7 8 9 10 11 12  | Next Page >

• Timeline chart in Excel

  - by Axarydax

  Hi, I'd like to see a timeline of events from a database in a "timeline chart", that should look like this: http://i46.tinypic.com/sw3dj5.png - I've made me a small c# program that paints this onto a Bitmap, but that isn't the way to go. I have input data that has 3 fields: StartX EndX Y 2596 15008 1 5438 6783 2 5450 5453 4…

  Read the article

• Copy first row in excel workbook to a new excel workbook

  - by user1667414

  How do I get the first row in an excel workbook & save it to a new excel workbook using .net c#? I dont know the amount of columns so need to get entire row. This what I have but the new workbook is blank (no row copied) Excel.Workbook xlWorkbook = xlApp.Workbooks.Open(file); Excel._Worksheet xlWorksheet = xlWorkbook.Sheets[1]; …

  Read the article

• Excel 'recently used list' not showing on start menu, but working within excel

  - by Margaret Thorpe

  In windows 7 when you pin Excel 2007 to the start menu, it usually has a small arrow which shows your recently opened documents. Mine only shows permanently pinned documents. It used to work until I tried Office 2010 and then uninstalled it. If I open Excel and click on the file menu, I can see all the recently opened documents so they are…

  Read the article

• Excel: Cell Value as Excel Document Metadata Property

  - by mjlefevre

  I know you can add custom Document Properties in Excel 2007. see: http://office.microsoft.com/en-us/excel/HA100475241033.aspx#5 But I thought there was a way to pull a value from a cell as a custom metadata property without code. Maybe I'm searching for it with the wrong terminology. Maybe it has to be done as a Named Range. I know this…

  Read the article

• Offset the tickmarks of a secondary axis

  - by Dan

  I would like to offset the tickmarks of a secondary axis in excel WITHOUT changing the minimum. Here is a very complicated VBA class that apparently solves the issue but I would like a solution that doesn't require me to construct my entire chart in VBA. Here is an example of what I mean (I removed the chart insides so it looks funny,…

  Read the article

• How to Use Sparklines in Excel 2010

  - by DigitalGeekery

  One of the cool features of Excel 2010 is the addition of Sparklines. A Sparkline is basically a little chart displayed in a cell representing your selected data set that allows you to quickly and easily spot trends at a glance. Inserting Sparklines on your Spreadsheet You will find the Sparklines group located on the Insert tab.…

  Read the article

• Remove Excel data link in Visio Drawing

  - by Ddono25

  I am creating a server topology for one of our SharePoint farms and thought it would be easy to just link the Excel spreadsheet with our server information to the Visio drawing to auto-populate some things. It didn't work out that well, but the drawing is finished without it now. I cannot remove the link between the Excel…

  Read the article

• Excel removing leading leading zeros when displaying CSV data

  - by Velika Kudac

  I have a CSV text file with the following content: "Col1","Col2" "01",A "2",B "10", C When I open it up with Excel, it displays as shown here: Note that Cell 2A attempts to display "01" as a number without a leading 0. When I format rows 2 through 4 as "Text", it changes the display to ...but still the leading…

  Read the article

• How to Merge Data From Multiple Excel Files into a Single Excel File or Access Database?

  - by lalabeans

  I have a few dozen excel files which are all of the same format (i.e. 4 worksheets per Excel file). I need to combine all the files into 1 master file which must have just 2 of the 4 worksheets. The corresponding worksheets from each Excel file are named exactly the same as are the column headers. While each file is…

  Read the article

• Excel fonts: Embedding or fallback options?

  - by Brendan

  I'm working with making a form in Excel instead of Illustrator or InDesign, as I typically do. One of the benefits about working with Adobe (and the subsequent PDFs) is that I control the fonts 100%. This is not the case when I am required to work with an Excel file that'll be passed around. So, is there a way to…

  Read the article

• Auto create folders using Excel field entries

  - by prrao

  I need to generate folders containing certain Excel field entries: Additionally, I need to append a date to the folder name based on that entry So If I have the above Excel table, I'd need the following set of folders to be generated in the same directory: Is this possible using a macro? Also, in case I…

  Read the article

• Microsft Jet oledb connection to excel loses formulae

  - by Saubhagya

  I have a dataset and I write it's values to an excel file using Microsoft Jet 4.0 Oledb provider. I want to put hyperlinks into the excel, for this I write "=HYPERLINK("http://www.abc.org/x.pdf")" in DS and then write it to excel. But when the excel is opened it prefixes a ' (quote/apostrophe) before the formula…

  Read the article

• Using VLOOKUP in Excel

  - by Mark Virtue

  VLOOKUP is one of Excel’s most useful functions, and it’s also one of the least understood.  In this article, we demystify VLOOKUP by way of a real-life example.  We’ll create a usable Invoice Template for a fictitious company. So what is VLOOKUP?  Well, of course it’s an Excel function. …

  Read the article

• How to best do foreach together with count in excel

  - by user3682637

  I have been trying to do some work in excel, but i seem to be stuck on one point in colum "A" i have: a, b, c, d, e in colum "B" i have: done, started, completed in colum "C" to colum "S" i have: some "X"'s but not in all fields. So my question is how do i do the following foreach row in excel.A …

  Read the article

• excel 2007 enter new date

  - by Lalajee

  I’m try to create a excel template which will have three fields I like to update automatically when it’s open. Fields which this template will have Current Date: 02/07/2012 Sheet Number: 25 Between Date: 02/07/2012 to 02/08/2012 When I open this template after 03/08/2012 this sheet will have new…

  Read the article

• excel chart dynamic range based on values

  - by andrewk

  I'm trying to create a chart that auto updates itself from a data provided. The range of the chart is always fixed/locked. The issue I'm facing is that when a value for a certain month is 0, I want it to skip to the last non-zero month . Meaning the ranges selected forming the chart should exclude the…

  Read the article

• Excel: Plot order total in map coordinates

  - by Phliplip

  I have a set of data that looks like this: -X--Y----Amount- AE 24 $178,00 Y 27 $162,00 AD 34 $680,00 AK 35 $178,00 Y 25 $29,00 U 23 $178,00 X 38 $193,00 AC 30 $226,00 AK 39 $152,00 AJ 34 $217,00 AC 35 $183,00 AA 22 $211,00 Z 19 $172,00 AJ 32 $187,00 AF …

  Read the article

• Excel - add target line to stacked bar chart

  - by Chris W

  I've got a stacked bar chart. I'm displaying a set of floating bars to represent hi/low ranges for some metrics, by using a transparent fill on the bottom section of the bar I achieve the desired look. What I now need to do is add a horizontal line across the chart to indicate how a particular…

  Read the article

• Excel 2010 -Excel cannot complete this task with available resources

  - by Jestep

  Getting this error when trying to sort a document (Excel cannot complete this task with available resources). Document isn't particularly large, about 4,000 lines. Can't seem to figure out why this would start on this. I can sort this same file fine on everything back to Excel 2000 on older…

  Read the article

• SQL SERVER – Preserve Leading Zero While Coping to Excel from SSMS

  - by pinaldave

  Earlier I wrote two articles about how to efficiently copy data from SSMS to Excel. Since I wrote that post there are plenty of interest generated on this subject. There are a few questions I keep on getting over this subject. One of the question is how to get the leading zero preserved…

  Read the article

• CUBEMEMBER and CUBEVALUE stop working after #PowerPivot upgrade to #Excel 2013

  - by Marco Russo (SQLBI)

  I found an issue upgrading an Excel workbook containing PowerPivot data from Excel 2010 to Excel 2013. All CUBEMEMBER and CUBEVALUE functions point to a cube name that has been changed between the two version – you have to no longer reference the PowerPivot Data name, replacing it with…

  Read the article

• Cell Transitions in Excel 2013 Preview–Fixed

  - by simonsabin

  If you’ve downloaded Excel 2013 and been working with it you may have noticed the new cell transition feature. Not sure why they put it in, it feels a bit like the aero interface which I understand has been dropped in windows 8. What you may have found is that the transition is buggy,…

  Read the article

• Globalize/Localize Excel Reports Using Spreadsheet

  - by mga911

  My company has new customers in Brazil and we realized that our excel reports are not working when our Brazilian customers tried to open the reports in their Brazilian versions of excel. For excel output we use spreadsheet gear in our vb.net web application. Our excel worksheets are…

  Read the article

• .net- open excel file, format the file and save

  - by Lock

  I have an ASP web service that uses the Crystal Reports API to download an Excel report. Now, there is a few things I do not like about the Excel report that Crystal generates: - The column widths are static (as in they are not adjusted for the content). - I can't format the header…

  Read the article

• Summing of total with dynamics rows coming external datasource

  - by Gainster

  I am using Excel 2010 and retrieving data from SQL analysis service. When I refresh the data from Excel, the rows all refresh as they are bound to an external datasource. I am adding a separate column with a formula to sum the totals. With an increment or decrement of these…

  Read the article

< Previous Page | 1 2 3 4 5 6 7 8 9 10 11 12  | Next Page >