Hello all,
How to create a chart using cells which contain multiple data? Every cell contains this information:
- date
- time
- % of utilization
Example of a single cell:
01/01/08 03:00:00
78.54%
I would like to create a chart where the X axis will be generated from date and time and the Y axis will be generated from the % of utilization. Is it possible? Please help me.
Thank you
Last edited by Link; 02-07-2008 at 01:27 PM.
Hi Link,
I think you have to split your raw data into 2 columns to be able to do this.
So you need to add 2 columns in your raw data that each contain part of the value you describe.
This is based on experience I have upto excel version 2003.
I don't know if excel 2007 is able to deal with this situation more easily.
J.
Hi,
This is a huge exel file with many worksheets and very much information. There are "uncountable" tables with cells which containing multiple data. I wouldn't want to waste time with adding rows. I have to create this chart monthly. Thank you for your hint but it isn't a good solution to me.
If the cells contain multiple data, Excel looks at them as strings (i.e. text). You'll either need to insert rows or columns and use Excels "Text to Columns" ability or write some pretty sophisticated macros. Sorry.
ChemistB
Indeed, there is no escape in splitting up the values to reach your goal.
An alternative could be that you request the party that is delivering the file to perform these splits for you.
If that is not an option then I guess it would be better if you receive the file in text. In that case you can paste the text in a sheet Column 1 and use Data > text to columns to split all data (like ChemistB mentions).
If that does not work out, indeed you have to create your own import process using VB macros to parse the data in the file....
If you need any help, just post an example file and maybe we can help you out.
J.
Hi Link,
Its not difficult to extract your Date/time and Percentages into separate columns. I'm not sure from your example whether the date is in one cell with a line break, but here's an example
oldchippy
-------------
If you are happy with the help you have received, please click the blue scales icon in the blue bar of the post.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
Originally Posted by oldchippy
Hi,
Thank you for your example,it could solve my problem but there is a line break in the cells and that formula doesn't work.Can you help me with this?
Thank you
Hello there,
It would be better if you could provide a small zipped sample of your worksheet; it would be easier to follow.
To post a zipped example, go to “My Documents” or wherever you have your file stored, right-click and “Send to > Compressed file”, then attach this zipped file to your post.
oldchippy
-------------
If you are happy with the help you have received, please click the blue scales icon in the blue bar of the post.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
Ok,
Here is an an example of my data
Hi,
I've managed to extract the percentages, but having trouble with the dates (yours in US, mine in UK format), but basically you need a formula to extract the first 17 digets in the cell and format to your date system mm/dd/yy hh:mm:ss
=VALUE(LEFT(Sheet1!A5,17)) try this on Sheet3 cell B2, auto-fill to the right and then down
oldchippy
-------------
If you are happy with the help you have received, please click the blue scales icon in the blue bar of the post.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks