Solved

excel produce a wire chart

Posted on 2011-03-15
2
305 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
2 Comments
 
LVL 33

Expert Comment

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

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

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvie…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Viewers will learn the basics of slicers and timelines for both PivotTables and standard Excel tables in Excel 2013.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…

758 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now