Hot answers tagged

4

Use the scatter chart. I use non-english Excel, so look at attached image, where to find the correct button.


2

You'll be wanting a Pivot Chart. Here's the steps for Excel 2010: Ensure all your data is in one column and has a header row. Select said column and in the Ribbon go to "Insert" -> "PivotChart" If you selected your data already, the "Create PivotTable with PivotChart" box should already be populated with the correct range of cells. Set up your ...


1

Since I can't upload images to imagur at work without going through an answer, I'll leave these here: While you could have the names at the bottom with a line graph, in my opinion it's a bit difficult to read. You wouldn't be able to have the Month on the Y axis though, since "James" would need points at 5, 12, 18, 6. The line would be straight up and down, ...


1

Copy Type Column and paste it 2 columns after your original Data then remove Duplicates from Data Tab you will have your 4 categories alone, in the cell near US Stocks use the following formula in G2: =SUMIF($A$2:$A$16,F2,$B$2:$B$16) $A$2:$A$16 is where your Type is with repeated category in the original Table and $B$2:$B$16 is your Market Value also in the ...


1

Follow the below steps to get this done To begin with, please see the sample of data I have considered for this task Step-1: Create a pivot table of your data as shown below: If you are new to pivot tables, then follow these steps: Go to Insert menu and select Pivot table In the Pivot table dialog select you table to give the input An empty ...


1

i have the same issue. I just used VBA to reset the chart's data source. It's not the most flexible code ever, but it solves my problem. Just to be clear, my data and chart sit in a tab called outputchart. that data source is called rngChartData, and this is a dynamic range using the usual OFFSET construction Sub UpdateChart() Sheets("outputchart")....


1

I found a slight workaround for column charts. If you want to use data points but don't want zeros to show. Change the data point number format to a custom format where zeros equal "". I used the code: _(* #,##0_);_(* (#,##0);_(* ""_);_(@_) All this is is the accounting format with the _(* #,##0_);_(* (#,##0);_(* **"-"**_);_(@_) replaced with _(* #...



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