Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Flexibly specifying data series in charts
I have tables with many columns. I want to create a chart that will allow me
to specify which columns to use for x- and y-axes, preferably with two pull-down menus. Basically, I want to avoid the present situation where I create a new chart every time I want to observe the correlation between two variables. Another refinement: Sometimes one column will indicate a category for data points (e.g., column title could be element name; categories: oxygen, hydrogen, aluminum, calcium, etc.). Can I make the charts to plot one or more categories as separate data series? (Again, preferably with a pull-down menu.) Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drawing Order of Data Series on Charts | Charts and Charting in Excel | |||
Disruption of order of data series in 100% stacked charts | Charts and Charting in Excel | |||
Getting charts to automatically pick data from a series | Charts and Charting in Excel | |||
How can you add the same data series to all charts in a workbook | Charts and Charting in Excel | |||
XL Charts: Let my mouse drag all data labels for a whole series. | Charts and Charting in Excel |