| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
create charts using concatenated ratios (e.g. 1:250, 1:325, 1:10)
I've written a formula that produces rations (e.g., 1:250) by concatenting
"1:"&(a6*w34). How can I persuade Excel to draw charts of the results? It wants to interpret them all as "1" Thanks for you help. |
|
#2
|
|||
|
|||
|
A concatenated cell contains a string. XL can only plot that on a
Category axis (x-axis for charts such as Line, Column, Area). It cannot use a string for a y-value. What you may want to do is plot the decimal equivalent and then use the ratio column as a label for the plotted series. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , =?Utf- 8?B?UHJvZiBKYWNr?= <Prof says... I've written a formula that produces rations (e.g., 1:250) by concatenting "1:"&(a6*w34). How can I persuade Excel to draw charts of the results? It wants to interpret them all as "1" Thanks for you help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create my own custom combination charts? | Charts and Charting in Excel | |||
| Can 1 create a excel dahboard charts that pulls from other Excels | Charts and Charting in Excel | |||
| Working with Charts | Excel Discussion (Misc queries) | |||
| Can't create dynamic charts | Charts and Charting in Excel | |||
| How do I create individual pie charts for 99 different employees? | Charts and Charting in Excel | |||
Linear Mode
