Tag Info

Hot answers tagged

2

There are at least three places to look: 1) System settings (Windows: Control panel, regional settings, Ubuntu: System Settings, Language support -> Regional formats which should reflect/be reflected by $ locale) 2) Excel / Spreadsheet settings: Excel, File, Options, Advanced (LibreOffice?) 3) Cell/Item/Object local settings: e.g. Right click 'Chart ...


2

This may not answer it 100%, but this seems like a great use for a PivotTable. Just a basic PivotTable where you put your X values in the columns, Y values in the Rows, and then you can add both the Sum of Amount and Count of Amount as your values. Sorting by both Row and Column will give you a coordinate system in the pivot table without having to resort ...


2

This behaviour is caused by a bug in the July 2014 update to Excel. If you uninstall the update, the problem will disappear. Microsoft will ship a fix soon. The support page for this update is here: http://support.microsoft.com/kb/2837600 That page also contains information about how to uninstall the update on your computer.


2

Assuming that your rows are B3 through B22, that you have to start counting at B3, and that there's nothing underneath them, you could use the following formula: =COUNTIF(B3:B100,"=3")/(COUNTA(B3:B100)) The function of "COUNTA" is to count every cell that is not empty. Any time a row is added underneath B22, the formula would automatically update to ...


1

Good question! It's a shame that Excel doesn't have such graphing capabilities "out of the box". I took the following steps: Add a column to your data with the width of the band (UpperBand - LowerBand). Use the "Stacked area" graph type and graph only the Lower Band and the Band width. Set the filling of the Lower Band to transparent and draw no lines ...


1

This worked perfectly for me. I used this code to have it edit all lines in all charts on all sheets of a workbook Sub ChangeLineType() 'This macro will print all embedded charts in the active workbook ' Application.ScreenUpdating = False Dim Sht As Object Dim Cht As ChartObject For Each Sht In ActiveWorkbook.Sheets For Each Cht In ...


1

The quick and easy way to accomplish this is to custom format your data label. Select a data label. Right click and select Format Data Labels Choose the Number category in the Format Data Labels dialog box. Select Custom in the Category box. In the format code box, enter 0%;-0%; and click Add. Close out of your dialog box and your 0% labels should be gone. ...


1

Assuming your data is set up correctly, you should be able to add accomplish this by: Add Data Labels Format Data Labels Check Label Contains to Series Name Uncheck Label Contains Value Check Label Position to Inside End Repeat for each series Delete the legend (which is almost always a good practice). But it sounds like your chart is trying to do too ...


1

For a vertical drop the stacked area series must only contain cells with data. If they include empty cells (or NA values), the area will be plotted to drop off to zero. You can either manually adjust the series formulas or use dynamic range names that automatically adjust to the data. Using a data sample similar to yours, please see the following ...


1

You're likely seeing either or both of: Page layout > Page setup > Margin > Custom Margins in Excel The empty cells surrounding your graph: I suggest you "Define a print area".


1

AFAICS in Office 2013, the default paste format is "Microsoft Office Graphic Object". If you are just pasting (not linking/embedding) then you could change the separators in Excel (as you are doing), use Paste->Special to specify one of the graphic formats, then change the separators back. If you are using Paste->Link or embed, once you have the result ...



Only top voted, non community-wiki answers of a minimum length are eligible