excel dynamic charting

  • Thread starter Thread starter bobf
  • Start date Start date
B

bobf

I successfully used Debra Dalgleish's method to create a
dynamic chart where my data was in columns. When I try to
apply the same approach to data that is ROWS, it doesn't
work. In fact my x axis labels should be Monday, Tuesday,
Wednesday, etc, but on the chart they are Monday, 4.6,
space, space, June 24 etc as it is looking downwards
rather than across. Any ideas, anyone. Thanks.
 
The formula for the chart values would be similar to:

=OFFSET(Sheet1!$B$1,1,0,1,COUNTA(Sheet1!$2:$2)-1)

and for chart labels:

=OFFSET(Sheet1!ChartValues,-1,0)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Excel Dynamic Charting in rows 0
Bubble chart labels on x axis 2
Dynamic X-Axis in Chart 2
Dynamic chart -easy question that has me stuck 5
Dynamic Ranges 2
Date on chart axis problem 2
rearrange data by day 4
dynamic plotting of charts 0

Back
Top