If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Can I import Excel charts into ACCESS for reporting? | Marjie | Setting Up & Running Reports | 0 | January 19th, 2005 06:31 PM |
Odd behavior in reports with multiple charts | Tom | Setting Up & Running Reports | 0 | January 16th, 2005 02:55 AM |
Why did Pivot table charts copied into workbook with standard cha. | TamaJo | Charts and Charting | 1 | October 26th, 2004 01:53 AM |
how to create customized stock charts? | namsilat | Charts and Charting | 1 | May 3rd, 2004 03:38 AM |
Creating a large number of charts automatically (repost) | Francine Kubaka | Charts and Charting | 0 | September 21st, 2003 09:16 PM |