Tag Info

Hot answers tagged

16

This is how I do it: Add a column and fill it with 1 (name it Count for example) Select your data (both columns) and create a Pivot Table: On the Insert tab click on the PivotTable | Pivot Table (you can create it on the same worksheet or on a new sheet) On the PivotTable Filed List drag Country to Row Labels and Count to Values Now select the pivot ...


15

You can get close in Excel: Create your graph, as you normally would by selected your data points and inserting a graph. Once you have your graph, select the actual graph item (In this case the bars themselves) Now right click the bar, and choose Format Data Point Go to the Fill tab Check Picture or Texture Fill Select your image from the File... ...


14

There is no official support for this in Excel; however, there is a hack to make it work using a scatter plot. This method is a bit complicated, but does not require an add-on like the other answer. I figured this out using the info from here, but doing a different method to make it work with a column chart. Essentially, the way this works is that you ...


11

[Back at home now, so have rewritten for Excel 2007] You can have a "primary" and "secondary" axis in some chart types (line, column and bar at least; maybe others) - they are in pairs so you can't have a secondary x-axis without a secondary y-axis, but you can make the secondary y-axis identical to the primary version, and then hide it, so it has no effect ...


10

Hopefully the following image is self-explanatory: The complete command sequence in Excel 2007 is: Select your chart Select Chart Tools → Design on the Ribbon Select "Select Data" Select "Hidden and Empty Cells" Select "Connect data points with line" Select OK.


8

Yes Right-click on the chart and choose edit. Right-click on the pie and choose insert data labels. Right-click on a data label and choose format data labels. You can choose Placement, set to Inside. You can check the box to show value as percentage.


8

Here is another solution using Excel 2013. All credits go to Rik who mentioned the People Graph app in a comment. Installation: Navigate to the People Graph app site with your internet browser Login with your Microsoft account Click "Add" Open Excel 2013 and write these values in the first 4 cells (A1:B2) Click "Insert" at the ribbon bar and choose ...


8

This walkthrough is based on Andy Pope's original tutorial here. Let's say this is the data you're starting with. There's a bit of data manipulation to do before we create the chart. In your example we want all the sectors to be the same size, but let's make things flexible and add in a sector weight column. eg if you wanted 'WORK' to appear as a ...


6

I've run into this myself for updating weather images from the Internet during a slideshow. Since Powerpoint stores the image files within itself while the slideshow is running, it does not update the images. This means you have to trigger it to update the links by using VBA code or use an add in like; Update links during slide show Add-in for PowerPoint ...


6

It's probably easiest to consider this combination chart as two separate charts, an XY(scatter) chart and a bar chart. The XY chart is pretty straightforward once you see it. You just need to create a three-column "set" for each timeline (series) you want: an X value, Y value and Label. Then, add an additional series for the X axis, using the labels as ...


6

Here is one way that might work for you. Set up the data like this: Make a column chart: Format the 'Actual' series, and put it on the secondary axis: Format the 'Target' series. give it no fill and a medium thickness border, and change the gap width to something like 25%:


5

iReport will not function correctly without a connection to JasperServer. If you're looking for easy reports your best tools are really excel and access. As far as end-user simplicity the buck stops there. If you're looking for something a bit more robust then I would take a look at any of the following for open source solutions. If you want to go ...


5

Give your column of timestamps a name, in the first row, say "Timestamp". Now create a Pivot Table with Timestamp used twice - once in the Values area (Count) and again in the Row Labels area. You can then select grouping on the Row Labels as days, hours, minutes, whatever. Then select Options | PivotChart.


5

Microsoft Visio


5

As W_Whalley has discussed this is because Excel is rounding the values displayed in the formula, the fix is to simply change the display formatting for the label, and here's how: Create the graph, add the trendline, make the equation label visible. Right-click the equation label and select Format Data Labels... On the Number tab select the type Number and ...


5

I always check Peltier's site for all my graphing needs. This should do it for you. http://peltiertech.com/Excel/ChartsHowTo/ClusterStack.html


5

I have 2 ways: 1. If you are using only the "1", "2" and "3" digits in superscript, you can change them to these characters: character ¹: in your keyboard: alt+0185 / US-International Keyboard: altgr+1 character ²: in your keyboard: alt+0178 / US-International Keyboard: altgr+2 character ³: in your keyboard: alt+0179 / US-International Keyboard: altgr+3 ...


5

You can solve this with a simple LINEST formula (without charting) For a 3rd degree array enter =LINEST(C2:C15,B2:B15^{1,2,3}) into four horizontal cells to get your equation coefficients (aX^3+bX^2+cX+D), and then just substitute for X LINEST for more complex regressions is covered here


5

On Linux there is: gnuplot matplotlib (scriptable with Python) dataplot pyxplot quickplot qtiplot Thease have, as far as I know, interactive modes.


5

It is very easy to make a chart like this in Excel. You'll just need to change your data layout. List all of your category labels are in a single column. Create a column for each category type (e.g. equities, corporate, sovreign...) For each category, just place the value in the appropriate categories column. Your data should look something like this: ...


5

Right click on a label and select Format Data Labels. Go to Number and select Custom. Enter #"" as the custom number format. Repeat for the other series labels. Zeros will now format as blank. NOTE This answer is based on Excel 2010, but should work in all versions


5

What you describe is a Marimekko chart, or variable width column chart. They can be created in Excel using the Area chart and a well-organised data layout. Excel MVP and charting guru Jon Peltier has a step by step tutorial here: http://peltiertech.com/WordPress/marimekko-charts/ Edit: The screenshot shows your data, the data layout required (truncated) ...


5

You can use the Excel Camera Tool to take a snapshot of cells or charts. Once they are placed where you like, they will automatically update whenever the original is changed. Here are instructions how to use it. It's a handy tool. Note: When using it to take a snapshot of the chart, select the cells surrounding the chart in order to get the shot. ...


4

Go to the Select Data dialoge box for the chart click Hidden and Empty Cells Change Show empty cells as to Connect data points with line


4

The following worked for me. First, install the add-in AutoEvents. In the example below, a continuous PowerPoint presentation of 2 slides is used (if you have more, change the if statement in the third macro to the number of your last slide). Create three subs, that do the same: Sub Auto_ShowBegin() Sub Auto_Open() Sub OnSlideShowPageChange(ByVal SSW As ...


4

You could use VBA to ensure that the maximum value is always a full hour, say, and that the minor unit is 5 mins and the major 10 minutes. The macro could get very complex depending on how much you want to automate. Much easier would be four worksheet cells where you can type in the desired min, max, major, minor as time values and the chart updates ...


4

Right click on the chart and choose Select Data. Select your series and choose Edit. Instead of having a "Series Values" of A1:A235, make it A22:A57 or something similar. In short, just chart the data you want rather than charting everything and trying to hide parts of it.


4

I can think of two possibilities: Create the Parts as individual charts in excel, copy the images into powerpoint, and use powerpoint animation to advance the images If you really want to do it in excel, write VBA macros to modify a single chart as required for each Part, and use Application.OnTime to fire the macros at the required interval.


4

You can write a vba user defined function to use the trend line formula to evaluate a given x Here's an example to get started Function TrendLineValue(x As Double) As Double Dim c As Chart Dim t As Trendline Dim s As String ' Get the trend line object ' this code assumes the first chart on the active sheet, ' and the first ...



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