| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
create chart from series grouped by value in another column
How to create a chart from series grouped by a value from another column?
Example The sheet has these rows: A, DATE, 1 A, DATE, 6 A, DATE, 7 B, DATE, 3 B, DATE, 15 B, DATE, 6 B, DATE, 6 A{1,6,7} is a series and B{3,15,6,6} is a different series. I have around 2000 different series like that in my excel. How can I auto-create charts for each series (i.e. not selecting each series one by one)? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I display multiple series in a pie chart? | Charts and Charting in Excel | |||
| How to hide a dummy series in a chart legend? | New Users to Excel | |||
| Create new series (on the same chart) for every change of values in a combobox | Charts and Charting in Excel | |||
| How to change Series order in a Combination Chart? | Charts and Charting in Excel | |||
| How to change Series Order in a Combination Chart? | Excel Discussion (Misc queries) | |||
Threaded Mode
