I figured it out accidentally!
When combining different chart types by pasting into another, it will take the chart type of the chart you are pasting and change the original. BUT you can select specific data series and change the chart type.
It works with filled radar graphs and radar...
Does anyone know if it is possible to combine different chart types? (i.e. a filled radar chart in the back of a normal radar chart?)
I try combing a filled radar chart with a regular one (by pasting it into it) and the last chart to paste is what chart type they all follow.
I could...
Ahh yes. But then the position of the bar moves as well.
You see, I want the bars and legend to do different things but they are linked.
For the bars, I want to keep it alternating (bright, light, bright, light)
but for the legend, I want to keep all the bright together and all the light...
Probably a simple problem that I just can't see how to solve.
See: http://cid-a16b2aba8a294b20.office.live.com/self.aspx/.Public/BarGraph.jpg
Originally, this was two sets of bar graphs. One set for a different user group.
I combined them into one graph, making one user group with a faded...
Hello everyone,
I really enjoyed the post on using Wingdings to replace radar charts. But now I have a few questions on editing.
http://chandoo.org/wp/2008/10/07/excel-radar-charts-replacement-spot-matrix-download-template/
If we were to just choose between 3 circles rather than 5, why...
I am currently working with about 50 sheets of data that are all in the same format.
I want to sum up the figures in specific cell positions (i.e. Sum up everything cell B2 for each sheet) and found that I could use 3D references.
From...
I was looking at some examples from http://chandoo.org/wp/2010/01/04/sales-dashboards/
and specifically, the "Excel based Sales Dashboard by Aires (Option 02)" has a dropdown option for different sets of data. but still, i'm not so clear on how Aires was able to create it without hard coding...
Is there a tutorial on how to create a drop down for different groups of data?
That would definitely beat hard coding buttons, I agree.
Thanks again!
Jade
Hi Hui,
Yes, I would like a chart based on the values in Row 51 (titles from Row 2 would be nice).
Only in columns A to F.
That would be superb if there was an option to select between the 6 products in A1 and have the data change accordingly. Maybe Data Validation comes into play here...
Hi Hui,
I uploaded two files here:
http://cid-9a617fc298848959.office.live.com/browse.aspx/.Public?uc=2&lc=1033
One is a working form control with radar chart. One is a table as you suggested.
Thanks for your help!
Jade
Thanks Clarity and Hui for the insight!
I found so much on pivot tables, that I completely dismissed using regular tables.
I used the "Totals Row" function, but for some reason, I can't seem to chart the data in that row. Is there something additional I must do to chart the data in the Totals...
Hello everyone,
I am given the task to create a dynamic dashboard within a few weeks and I want to give the user the capability to have some sort of form control to choose which groups of users to compare.
I was able to do the following Excel - but it was only with three checkbox form...