Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Histograms chart with two series, each with different X values
Is there a way to get a histogram chart in excel with two series, each
with different X values? for e.g. Series1 a 10 b 20 c 30 d 40 Series 2 a 100 d 400 b 200 (assume 1st column represents X values and 2nd column represents Y values) note that though some X values are the same in both series, there are some inconsistencies. is there a way to get a histogram chart in excel, which would automatically put together the things that belong to the same X ? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Histograms chart with two series, each with different X values
Charts show the data they're given. You would have to either manually move
data around in the sheet, or write formulas (lookups, etc) to do this for you. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Mahurshi Akilla" wrote in message ... Is there a way to get a histogram chart in excel with two series, each with different X values? for e.g. Series1 a 10 b 20 c 30 d 40 Series 2 a 100 d 400 b 200 (assume 1st column represents X values and 2nd column represents Y values) note that though some X values are the same in both series, there are some inconsistencies. is there a way to get a histogram chart in excel, which would automatically put together the things that belong to the same X ? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using offset in series values of a chart | Charts and Charting in Excel | |||
chart x-axis values appear as a series | Charts and Charting in Excel | |||
Read series values range of a chart | Charts and Charting in Excel | |||
Chart -- How to chart 65536 values in 1 series? | About this forum | |||
Create new series (on the same chart) for every change of values in a combobox | Charts and Charting in Excel |