UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Chart Report Design - Can't See All Data Labels To Change Font, Access 2010    
 
   
Brandi
post Feb 17 2018, 03:19 PM
Post#1



Posts: 1,666
Joined: 24-June 04



I have a report that is a Chart.

It displays the correct information and has several data series bars.
I am trying to change the size of the font to display in a smaller size over each bar.

For some reason, even though the data is correct on the chart, when I go into the design of the chart report the data table is pointing to some very old information which doesn't have the same number of data bars and therefore only lets me change the font on a few data bars but not the real number of bars that I need to change. so some bars have the font size I want and others have a larger font size.

Do you know why the data table might be displaying some old information?

The source of the chart report is correct and does display the right data. It is just in the design that the data table seems odd.

Thank you.
Brandi
This post has been edited by Brandi: Feb 17 2018, 03:20 PM
Go to the top of the page
 
GroverParkGeorge
post Feb 17 2018, 03:55 PM
Post#2


UA Admin
Posts: 33,536
Joined: 20-June 02
From: Newcastle, WA


IIRC, what you see in design view is a cached representation of the actual data as it will be used, not necessarily the values at runtime, but I tend to regard Excel as better suited to most common graphic reports.
Go to the top of the page
 
Brandi
post Feb 18 2018, 08:26 AM
Post#3



Posts: 1,666
Joined: 24-June 04



Is there a way to make Excel open a chart report based on an Access query?
So the user wouldn't have to do anything but press a button in Access?

Thank you.
Brandi
Go to the top of the page
 
GroverParkGeorge
post Feb 18 2018, 09:41 AM
Post#4


UA Admin
Posts: 33,536
Joined: 20-June 02
From: Newcastle, WA


Yes. It's not simple, but very doable.

Create an Excel workbook with a table that has, as its datasource, the query in Access.

THen build your chart in that Excel workbook using the table in it.

Now, it's going to be more involved than that, but basically, that's all there is to it.

Save this workbook as a template, if you want, and save each new iteration as a new Excel file. Or just reuse it as required.

The steps are illustrated in these screenshots. Of course, you can apply much more elaborate formatting and calculations than these simple starters.
Attached File  DataConnectionExcel.jpg ( 53.79K )Number of downloads: 1

Attached File  SelectAccessSource.jpg ( 74.39K )Number of downloads: 0

Select Either a table, or more likely, a query
Attached File  SelectQuery.jpg ( 27.8K )Number of downloads: 0

Place the table in a convenient location in the workbook.
Attached File  CreateExcelTable.jpg ( 27.02K )Number of downloads: 0

Excel offers many charting options, styles and formats
Attached File  multiplechartioptions.jpg ( 42.51K )Number of downloads: 0

Basic chart created in Excel from Table. Format as required.
Attached File  chart.jpg ( 127.59K )Number of downloads: 0


Save this workbook.

When you open it again, refresh the data to get the current data. You can do this manually or set it to do so when the workbook opens.

Attached File  DataRefresh.jpg ( 69.81K )Number of downloads: 0
Go to the top of the page
 
Brandi
post Feb 19 2018, 10:09 AM
Post#5



Posts: 1,666
Joined: 24-June 04



Thank you. I probably won't get to this today but I will let you know how it works.
I am very familiar with Charts in Excel but haven't use Access as a data source before.

Brandi
Go to the top of the page
 
GroverParkGeorge
post Feb 19 2018, 04:57 PM
Post#6


UA Admin
Posts: 33,536
Joined: 20-June 02
From: Newcastle, WA


Good luck with the project. Please let us know how it goes.
Go to the top of the page
 
Brandi
post Feb 26 2018, 04:00 PM
Post#7



Posts: 1,666
Joined: 24-June 04



Got it to work. Thank you so much for your help.
Brandi
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    25th September 2018 - 09:48 PM