LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
hmm hmm is offline
external usenet poster
 
Posts: 175
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Drawing Order of Data Series on Charts Eddie McGlone Charts and Charting in Excel 1 September 6th 07 04:08 PM
Disruption of order of data series in 100% stacked charts Sylvain Charts and Charting in Excel 4 September 21st 06 01:38 AM
Getting charts to automatically pick data from a series Salmonh20 Charts and Charting in Excel 3 April 8th 06 07:41 PM
How can you add the same data series to all charts in a workbook MBubier Charts and Charting in Excel 3 January 30th 06 02:18 PM
XL Charts: Let my mouse drag all data labels for a whole series. Stuart Bratesman Charts and Charting in Excel 1 August 10th 05 04:21 PM


All times are GMT +1. The time now is 09:50 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"