Solved

excel produce a wire chart

Posted on 2011-03-15
2
314 Views
Last Modified: 2012-05-11
using excel can you create a wire chart so with multiple values you can see the effect of increase or reduction in spikes?

I have attached sample data. testx.xlsx
0
Comment
Question by:Matt Pinkston
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 33

Expert Comment

by:jppinto
ID: 35141492
What do you call a "wire chart"?!?
0
 
LVL 33

Accepted Solution

by:
Rob Henson earned 500 total points
ID: 35173330
I am guessing you mean a Radar chart.

The problem with using a radar on the dataset you have is the range of values; minimum 57 and maximum 300,000. The small values end up as a dot in the middle of the radar with one line visible for the high values.

Or is that the problem you are trying to overcome???
0

Featured Post

Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa‚Ķ

635 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question