Tag Info

Hot answers tagged

4

I believe the color and size are both the Speed of Onset. Vulnerability corresponds to the color of the area under the dot (Green, Yellow, Red). Higher values of V trend towards red squares. Partial Answer: This is as far as I could get before I had to leave for the day: It's a bubble chart. I typed up the data in the sample for points 1 - 12. Next, I ...


2

This analysis can be easily completed by using a PivotTable to do the counting and a PivotChart to visualize. Here is the finished product with data similar to yours. When you set up the PivotTable, you will want to determine the ideal way to do the group of MONTH and EVENT. It is possible to get different charts depending on if they are both rows or if ...


1

For your Pivot Chart to work correctly, you'll need to setup your Pivot Table like this: Legend (Series) Agent Axis (Categories) Date Values Sum of Closed Tickets Your chart will then reflect the changes. This assumes your initial data set has at least those three columns (agent, date, closed ticket count). Once setup this way, you can group your date ...


1

You might simply apply a logarithimic scale (select Y axis -> format axis [or double-click on axis] -> axis options -> logarithmic scale with base of 10).


1

As Jon Peltier mentions in the answer to the question linked to by Mate Juhasz, a panel chart might be more appropriate for your situation. It can show an overall view, with a detail of the contact points. Excel can easily make this type of chart: By using similar proportions in each chart, the line slope is the same. But the intercept points can be ...


1

Please see the picture below how you can split your data. Also I've applied a date horizontal axis to make regression sense.


1

In Word 2010 you can set the wrapping style to "top and bottom", which unlocks the "Distance from text" setting. Not sure if this is in 2007, too, though.


1

You can use shift+enter instead of enter. This will insert a line break instead of a carriage return and preserve the justified text of the paragraph.


1

You can run the following macros to set the limits on the x-axis. This kind of x-axis is based on a count, i.e. just because the first column is labeled some number, it is still 1 on the axis scale. Ex. If you want to plot columns 5 through 36, set 5 as the x-axis minimum, and 36 as the x-axis maximum. (Do not enter a date for the kind of scaling you're ...



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