Dynamic Charting

**oldchippy** · 04-23-2008, 03:51 AM

Hi,

Can't you just right-click on the chart, select Chart type and click Bar?

**robert111** · 04-23-2008, 07:36 AM

old chippy - i think the issue is that the data is in rows and the formulae he has for dynamic charts are based on columns...he may want a line chart

**k_excel** · 04-23-2008, 08:53 AM

I apologize for any confusion, but the direction the data is going is the problem. I am already using a bar chart, if you look at the link from my original post, it shows setting up your actual data in a clean little horizontal table so the offset formula is reading an entire column of data, from top to bottom. In my spreadsheet, the data is going straight across and I can't get the formula to work to even create the chart since my data is vertically oriented. It has something to do with the formula, either I need to modify it, but don't know how, or I need to use a completely different one.

**ChemistB** · 04-23-2008, 02:11 PM

See my post here.
http://www.excelforum.com/showthread.php?t=642649

Is that what you are looking for?

ChemistB

**gshock** · 04-23-2008, 04:59 PM

Originally Posted by ChemistB

See my post here.
http://www.excelforum.com/showthread.php?t=642649

Is that what you are looking for?

ChemistB

ChemistB beat me to it, but that should do the trick for you. I incorporated ChemistB's suggestions and they work great!

Goodluck,

-gshock

**k_excel** · 04-25-2008, 11:19 AM

hi, i think this may be it, but i'm not quite sure since i'm new to this way of charting. it's so confusing trying to apply it to an existing spreadsheet

. below is the spreadsheet in question, i only need to chart Value F that's all, but i would need a separate chart for each section. so i would need, one for Cars, one for Trucks, etc, etc. so will this work for this situation? also, i only need the last 13 months, so i can see the trend, ex: march 07 - march 08, but setting up the length was the easy part.

**gshock** · 04-25-2008, 11:23 AM

Originally Posted by k_excel

hi, i think this may be it, but i'm not quite sure since i'm new to this way of charting. it's so confusing trying to apply it to an existing spreadsheet

. below is the spreadsheet in question, i only need to chart Value F that's all, but i would need a separate chart for each section. so i would need, one for Cars, one for Trucks, etc, etc. so will this work for this situation?

k_excel, yes, this will work perfectly for what you're doing. I'm doing the exact same thing. I only want to chart one thing at a time, I just created separate charts for each one. I still create all the Dynamic range names, but each chart only graphs one range name.

Let me know if this is unclear and I can show you the chart I created. You can pick it apart if you need to.

-gshock

Dynamic Charting

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Dynamic Charting

This should help.

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions